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