2003 Links

D

Denise Carr

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

Maybe it'll work for you.
 
Top