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