Don't update excel links

J

JacoH

In Excel 2000 when I open my workbook I don't update my Links and it shows me
the value.In Excel 2003 when I don't update my link it just shows me a error
instead of the value.
What can I do so that it shows me the value and not the error?
 
D

Dave Peterson

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/[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top