2003 Links

[Guest]

When I open a ss in 2000 and say I don't want to update the links it shows
the numerical data but if I open it in 2003 it shows Values instead can
anyone help or explain why this happens.

 

[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]

Maybe it'll work for you.