Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Guardian
 
Posts: n/a
Default External Links on open and Excel 2003


khoff Wrote:
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!


---
Message posted from http://www.ExcelForum.com/

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!

Guardian


--
GuardianPosted from http://www.pcreview.co.uk/ newsgroup access

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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/groups?thre...GP11.phx .gbl

Maybe it'll work for you.

Guardian wrote:

khoff Wrote:
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!


---
Message posted from http://www.ExcelForum.com/

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!

Guardian

--
GuardianPosted from http://www.pcreview.co.uk/ newsgroup access


--

Dave Peterson
  #3   Report Post  
Guardian
 
Posts: n/a
Default


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


--
GuardianPosted from http://www.pcreview.co.uk/ newsgroup access

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.

Guardian wrote:

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

--
GuardianPosted from http://www.pcreview.co.uk/ newsgroup access


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
trying to open an excel file in excel 2003 Edward Letendre Excel Discussion (Misc queries) 1 June 3rd 05 02:22 PM
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM
If I don't have children open I get #REF! where external links are Colettb Excel Discussion (Misc queries) 0 February 2nd 05 05:49 PM
Automatic links in Excel 2003 Jim Bud Excel Discussion (Misc queries) 4 January 13th 05 03:57 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"