Update Links-Excel 2003

[Guest]

Hello,
I am new to Excel 2003.
I have a file B which is linked to file A.When i open file B i get a
message asking whether to update/Do not update links.Whatever option i choose
i get a Value error in all the linked cells of file B.
This is happening only in the case of this particular file.In other files if
i choose not to update then my values remain intact and i dont get any error.
Any suggestions??

 

[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 ok for you.

 

[Guest]

thanks Dave..
but what do i do abt it ?Or do i have to live with it.
Also now i am getting this problem with more workooks

 

[Dave Peterson]

You'll have to read Jim Rich's post and then edit the registry to see if that
works for you.