update links - problem

M

Micha³ S

Hi
I have big problem with update links in excel file
When I'm opening excel file I click button "don't update links" (I need
'old data') but I still get fields with "#ARG!" Why ? and how can I resolve
this problem.
Thanks for help
 
D

Dave Peterson

I bet #ARG! translates to #Ref! in English.

If I'm correct:

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