#REF Displayed - follow up message

R

Richard

-----Original Message-----
There are formulas, but they may be as simple as

='C:\foo\bar\[xyz.zls]SheetX'!Y99

Show us the *full* formulas in the cells containing external reference links
that evaluate to #REF! or #N/A.
Click to expand...

In the examples below, both data links access data from
the same file and worksheet. One formula works, the other
does not. Once I open the file the formulas link to, all
formulas work. There are a total of 21 cells that link to
data from the same file. 19 links work, two return the
#REF or #N/A.

Here's a forumla from a link that currently returns #N/A.

='D:\Documents and Settings\All
Users\Desktop\CMCMenu\Files\B. MENU SYSTEM\1. Menu System
Files\[2. CMC Week-2.xls]Data Entry'!$C$74

The data from the referenced cell = "Master Spreadsheet
Day 10"

Here is a formula that is working.

='D:\Documents and Settings\All
Users\Desktop\CMCMenu\Files\B. MENU SYSTEM\1. Menu System
Files\[2. CMC Week-2.xls]Data Entry'!$C$75

The data from the referenced cell = "Master Spreadsheet
Day 11"


Thanks
 
Top