Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 3rd 06, 05:19 PM posted to microsoft.public.excel.misc
ARW
 
Posts: n/a
Default Dynamic Links Excel 2003

Good afternoon. I use an excel 2000 file that has dyanmic links in it used
for stock quotes. I save that file onto a disk and move it to another
computer that also has Excel 2000, but no internet connection to receive the
dynamic information. Upon opening it asks me if I want to update the links,
I say no and it lists the static value at the point of save from the original
computer. I upgraded computer #2 to excel 2003 and even though I say I do
not want the links updated, it will now NOT open with the last static value
saved from computer #1. I know have to do the copy and paste special
gyration to get it to open with the static values. Is there a way to have it
open the file like it did in Excel 2000 with the last known value and not
have to go through the paste special routine? Please advise.

Thank you.

  #2   Report Post  
Old January 3rd 06, 05:48 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Dynamic Links Excel 2003

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.

ARW wrote:

Good afternoon. I use an excel 2000 file that has dyanmic links in it used
for stock quotes. I save that file onto a disk and move it to another
computer that also has Excel 2000, but no internet connection to receive the
dynamic information. Upon opening it asks me if I want to update the links,
I say no and it lists the static value at the point of save from the original
computer. I upgraded computer #2 to excel 2003 and even though I say I do
not want the links updated, it will now NOT open with the last static value
saved from computer #1. I know have to do the copy and paste special
gyration to get it to open with the static values. Is there a way to have it
open the file like it did in Excel 2000 with the last known value and not
have to go through the paste special routine? Please advise.

Thank you.


--

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 2000 to 2003 update links doesn't work properly any suggest Richard Excel Worksheet Functions 2 September 8th 05 01:06 AM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
Help in Excel 2003 Charlie Rowe Excel Discussion (Misc queries) 0 June 13th 05 04:31 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM


All times are GMT +1. The time now is 06:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017