External Links on open and Excel 2003

K

khoff

I am opening a spreadsheet in Excel 2003 that contains
links to external sources. This spreadsheet was created
in Excel 97. When I open it, I am prompted to update or
not update. I choose don't update, as I don't have the
linked files. BUT, it seems that Excel tries to update
anyway because it is the same result as if I hit update,
and all of my values are gone. This seems to be a change
from excel 97 as excel 97 left the values.

Any ideas? I likely have a default setting incorrect
somewhere.

Thanks!
 
G

Guardian

khoff said:
I am opening a spreadsheet in Excel 2003 that contain
links to external sources. This spreadsheet was create
in Excel 97. When I open it, I am prompted to update o
not update. I choose don't update, as I don't have th
linked files. BUT, it seems that Excel tries to updat
anyway because it is the same result as if I hit update
and all of my values are gone. This seems to be a chang
from excel 97 as excel 97 left the values

Any ideas? I likely have a default setting incorrec
somewhere

Thanks
Click to expand...
I am opening a spreadsheet in Excel 2003 that contains
links to external sources also but it was created
in Excel XP. When I open it, I get the same error as you.
The only thing i can find on this problem is that it is a cell
formating change from the older versions to 2003. If
Anyone knows of a fix or what setting is off please let me
know.

Thanks!

Guardia
 
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.
 
G

Guardian

I tried the registry edit and it worked for part of the problem. No
when I tell it not to update it will leave the last saved data. Bu
the rest of the problem where it should update the external links doe
not work still. Thank you very much for the registry information i
helped allot but if anyone knows the answer to the rest of the proble
PLEASE let me know
 
D

Dave Peterson

I don't see your explanation of what the rest of your problem is.

You may want to post that portion of your question again.
 
Top