I regret I have to say that I don't understand a word of what you're saying

Can you give an example of exactly what is bothering you? Formulas, values,
expected and actual results, anything that might show what your problem
is....

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill R" wrote in message
...
Thanks Niek.

The formulae in SpreadsheetA are in the format
='[SpreadsheetB.xls]Data'!$V$5

The data to which they refer in SpreadsheetB is numeric.

All the data cells SpreadsheetB are formatted identically

What I mean by "Given that the displayed data is correct proves the link
is correct "? is this. If it is capable of displaying the correct data
from the cell in SpreadsheetB the link is correct. The mystery is why the
display changes to the error message but only on some cells when
SpreadsheetB is not open. If the formula returned correct information (or
even incorrect information) consistently then it should be easy to trace
and correct. It is the inconsistency that's beating me!

Another oddity is that when going into Formulae Editing, both Trace
Dependents and Trace Precedents return arrows between the error cell (say
A30) and a cell in row C (C28) which is a text cell with absolutely no
connection to the error cell. This is consistent through the column in
Spreadsheet A (those that return correct information and also those that
return an error).

Bill R
"Niek Otten" wrote in message
...
Hi Bill,

Impossible to answer if we don't get the *exact* formulas in SpreadsheetA
and the formulas or values in SpreadsheetB
And what do you mean he "Given that the displayed data is correct
proves the link is correct "?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Bill R" wrote in message
...
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