Thread: #N/A error
View Single Post
  #4   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Default

Quote:
Originally Posted by Bill R[_3_] View Post
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
__________________
Thanks
Bala