The problem occurs when I click 'Yes'. My Total file will not update with
the most recent data until each individual file has been opened and saved.
With 97 it would update without having to open each individual file.
--
Tracy B.


"Dave Peterson" wrote:

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 help you.

Tracy B. wrote:

My office recently upgraded to 2003 from 97. We experienced #REF errors in
many cells in our workbooks after the upgrade. To eliminate the #REF errors
I re-established most of the links in the A) Source or Data Workbook; B)
Target or Dept Workbooks; and C) Target Total Workbook.

Now we have a new problem. When data is changed in Workbook A, all B
Workbooks must be opened in order for Workbook C to update. In 97 we only
had to update data in A, then open Workbook C. All Workbooks would update
and the correct data would filter to Workbook C.

It would appear that there is now some sort of hierarchy of links between
Workbook A, Workbooks B, and Workbook C. Unless you open each individual
Workbook, Workbook C will not update.

How can we overcome this problem? It is too time consuming to open each
Workbook B individually.

Help?
Tracy B.
Feb 20/06
12:46 pm
--
Tracy B.

--

Dave Peterson