Cancel automatic updates of linked values
You might try going to ToolsOptionsCalculation tab. Click on Manual
Calculation radio button. You might accomplish it this way.
God Bless
"Bill Hutchinson" wrote:
I want to disable updates of automatic links in Excel. If I receive a
workbook with cells that another user has linked to a file from their
temporary folder (emailed attachment?), I can't stop Excel from trying to
update the link and therefore get #REF! msgs.
When I go to Startup Prompt in the Edit Links section and select "'Don't
display the alert and don't update automatic links" option, the file still
doesn't stop returning the error msg.
|