Error message #N/A appears in linked cells
Here is a sample formula:
='\\sh02y291\Resource Management$\6300-50000\Period 3\[MPS Period 3
6300-50000 roll-ups.xls]MPS'!G5
There is only one source book, although I have other formulas with multiple
source books that don't have a problem.
No merged cells and the workbooks aren't shared.
Thanks
"Bill Manville" wrote:
I guess I must be missing something.
Please post an example of a formula that is delivering #N/A when the
source book is closed.
Is more than one source book referenced and if so are the errors
specific to one source book?
Are merged cells or shared workbooks involved at either end of the
link?
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|