Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 7th 05, 10:38 PM
Richard
 
Posts: n/a
Default Excel 2000 to 2003 update links doesn't work properly any suggest

We have an advance Excel spreadsheet that has many links to other worksheets
and someone when you load it in Excel 2000 it ask is we want to update the
links and we answer no and the formula etc.. are all working, but when you
bring the file into Excel 2003 then the value disapear and nothing is working
properly.

  #2   Report Post  
Old September 7th 05, 11:04 PM
Ken Wright
 
Posts: n/a
Default

In 2003 if you do Tools / Options / Edit, is the option 'Ask to update
Automatic links' ticked? if not then do so.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Richard" wrote in message
...
We have an advance Excel spreadsheet that has many links to other
worksheets
and someone when you load it in Excel 2000 it ask is we want to update the
links and we answer no and the formula etc.. are all working, but when you
bring the file into Excel 2003 then the value disapear and nothing is
working
properly.



  #3   Report Post  
Old September 8th 05, 01:06 AM
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.

Richard wrote:

We have an advance Excel spreadsheet that has many links to other worksheets
and someone when you load it in Excel 2000 it ask is we want to update the
links and we answer no and the formula etc.. are all working, but when you
bring the file into Excel 2003 then the value disapear and nothing is working
properly.


--

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 Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
find and replace links in Excel 2003 MAndrews Excel Worksheet Functions 2 June 3rd 05 06:18 PM
excel 2000 and 2003 cwwolfdog Excel Discussion (Misc queries) 1 March 29th 05 01:32 PM
Can Excel 2000 be upgraded alone to 2003 on an NT4 machine? Andymak252 Excel Discussion (Misc queries) 1 January 11th 05 11:53 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 07:35 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