Are the references which do not update correctly contained in formulas with
Excel functions? Some functions, such as COUNT and COUNTIF, do not work with
closed workbooks. COUNT, COUNTA, or COUNTIF could be replaced with an
equivalent SUMPRODUCT formula, which does work with closed workbooks.

Hope this helps,

Hutch

"Mike" wrote:

I have a spreadsheet that references cells on a main spreadsheet for all
of its information. When I open this spreadsheet some of the cells do not
update correctly and display a #N/A. All of the cell references have the
same format so why do some update correctly and others do not? If I open the
main (referenced)spreadsheet the dependent document updates correctly,
immediately.
I will need to correct this issue. I was thinking as a last resort I
could have an automatic macro that opens and closes the source document
invisibly just to ensure the cells update correctly but I am sure there is a
better way to fix this problem (like fixing the cell references!). Any
ideas?
--
Michael J. Nowak
Energy Systems/Dow Chemical
Texas City, TX