Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
excel 2000 and 2003 | Excel Discussion (Misc queries) | |||
Can Excel 2000 be upgraded alone to 2003 on an NT4 machine? | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |