Update Link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Excel Files - Shared Server 2
Saving through a network affecting ability to update automatically 1
How to create absolue path link to another workbook (Excel 2003) 1
#VALUE! when updating links 1
Why doesn't Excel 2007 automatically update links in Trusted Files 0
Update Files Automatically with Links 1
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
File Download - Security Warning 5

Back
Top