Problems with links under Excel XP opening Excel 98 files

M

Markus Peuler

When I open an Excel 98 file containing links to other
files under an Excel version earlier than XP (I suppose
it is Excel 2002), the values resulting from the links
were displayed, even if the source file was not available
any longer. However when I open the same file under Excel
XP, the result of the link is #Ref and the value is not
displayed any longer. Is there a possibility to make
these values visible again?
 
J

Jan Karel Pieterse

Hi,

Try setting calculation mode to manual before opening the
file.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 

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