I've never seen excel not update the links when I chose to update the links.

You may be able to force an update by:
selecting all the sheets
select all the cells
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all
ungroup the sheets

If you do this once (and save the workbook), maybe it'll wake excel up.



Tracy B. wrote:

Dave Peterson, I want to update my total file. I click "yes" when I open the
total file. The total file does not update with the new data unless I open
all other files before opening the total file. I want the total file to
automatically update with the new data without opening the other files. I
could do this in our old 97 version. Any other suggestions?
--
Tracy B.

"Dave Peterson" wrote:

That message may apply only for #value errors.

Post back if it fails.

In fact, post back either way.

Thanks,

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


--

Dave Peterson