View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Hutchinson Bill Hutchinson is offline
external usenet poster
 
Posts: 1
Default 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.