Quote:
Originally Posted by Bill R[_3_]
I have SpreadsheetA which (in a column) takes data from SpreadsheetB (in a
row). (A simple = ...). So far so good and both spreadsheets are saved and
closed. The correct information is displayed in SpradsheetA on opening but,
on opening SpreadsheetB information in ONLY some cells change to #N/A.
Given that the displayed data is correct proves the link is correct but why
should it change?
Any suggestions gratefully received as I just can't think of an answer.
Thanks.
Bill R
|
If you are using excel 2007,make sure Excel Options -Advanced-"Update links to other documents" is checked in
all the best