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