Good Morning All,
Using Excel 2002

I have several workbooks in which all data in cells come from
links of other workbooks which are all located in "My Documents". When I
open both workbooks I get the message box about the workbook containing
links to other data sources. When I click on to update the data the first
workbook takes a few seconds to update all the data and opens up the
workbook with all the data readable. However in the 2nd workbook, after
several seconds, it opens but none of the data is displayed. All the cells
have the #VALUE! error. This forces me to open up the source workbook(s) to
display the data.
I am trying to figure out why the first workbook opens with all
the updated data (without the source workbook(s) opening) while the 2nd
workbook does not update the data unless I open up the source workbook(s).
I would like to update all information without having to open the source
workbook(s). Any help would be appreciated. Thanks.

Mike