View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.links
Jake Jake is offline
external usenet poster
 
Posts: 83
Default 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