Cancel automatic updates of linked values
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.
|