Update Link

M

Monkey

I have got a problem of Excel update link after upgrade to Office 2003.
I have create 5 excel files which is linked togather. In the 1st one, it
contains raw data, and each of the other make use of the result of the
pervious file.
1 --> 2 --> 3 --> 4 --> 5
Data

When I open the 5th file, it ask me to update link, form the background I
can still see the values, however no matter I choose "update" or "do not
update" the value turns into error. I have to open the 4th and 3rd file in
order to give my value back. This does not happen when I open the file in
Office 97. Can anyone help to solve my problem. Thanks.
 
F

Frank Kabel

Hi
as Excel 2003 re-calculates the entire sheet (if it was saved in a previous
version) and Excel can't lookup multiple levels of closed workbooks no chance
to prevent this other than first open all these files, save them in Excel
2003 and try again
 
Top