Thread: remote links
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

That other program is another excel workbook, right?????


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

Maybe it'll work for you.

mcarrington wrote:

I am trying to open a worksheet with links to another program that I do
not have. As such, I do not want the links to automatically update when
I open the workbook. Even though I select "do not update", the links
still update and I get a bunch of error messages in all of the cells.
Any ideas?

--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=469585


--

Dave Peterson