I get this error frequently, it is caused because the files being linked to
are large and the linked data can not be retrieved unless the source files
are open.



More annoyingly sometimes opening the files with the links in I get an error
message saying that there is not enough memory to open the file with the
links and then the file opens but with none of its formatting.

The only way round is to open the large source files first and then the file
which links to them.



I do rather bring it on myself by having files of several mb size linking to
about 6 - 8 other files, often 2 or 3 of these source files are large too.



My advise is to use manual calculation (calculate on save, which prevents
lost data when excel crashes, another side effect of numerous links) and to
always open any files being linked to (edit links, open source). Links to
unopened files can give error messages, or more worryingly inaccurate
results.

Barbara







"Bill Manville" wrote in message
...
Jake wrote:
Here is a sample formula:


Nothing obvious, I fear - but you knew that.
Do the cells in the source book referenced by the formulas that return
#N/A themselves contain formulas?

If so, we might be looking in the wrong place and find that the cells
in the source book (as saved) themselves contain #N/A and so are being
faithfully represented. When you open the source workbook though it is
recalculated and you don't see the #N/A ??

I'm largely out of ideas - haven't experienced this issue myself - or
heard about it from anyone else. The only workaround I can suggest is
opening the source workbook.

I'm willing to look at the workbooks if you would like to send them
(though possibly the problem won't transfer with them). Bill
underscore Manville at Compuserve dot com

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup