View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Bowman Carl Bowman is offline
external usenet poster
 
Posts: 21
Default Message: Links not updated because file not recalculated before sa

I keep getting a message when attempting to open a linked worbook that the
links were not updated because the file was not recalculated prior to saving.
I really don't want to update the file before saving because it opens
read-only and I refresh the data anyway once it is opened. This message is
interupting a macro I am running to perform the tasks. What is the code I
need to enter in the macro to say "OK" to the question it asks as to whether
I want to update links with the current data? I have "UpdateLinks:=0" in the
macro when the file is opened but that does not help. Thanks.