View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default DO NOT update links doesn't work for me.

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Hal wrote:

I have a workbook that contains links to other remote data sources and when I
select the start-up prompt option that says "don't update" so that excel will
use the previous information, excel tries to update and returns error codes.
How do I work with the existing data and stop the workbook link from trying
to update when the source file is not present?
--
Now if only I could get the pod door open.


--

Dave Peterson