#REF displayed instead of linked data

[Richard]

I have a spreadsheet linked to data in another
spreadsheet. In some cases the linked data does not show
up. Instead of the correct data being displayed, #REF, or
sometimes #NA is displayed. Other links to similar data
in the same spreadsheet work fine. If I open the linked
spreadsheet then all data links work fine... but only if
the linked spreadsheet is opened.

There are no formulas or calculations being performed. I'm
just displaying data from a cell in another spreadsheet.

I'm using Excel 2002 in Windows XP.

Anybody with some any ideas? Thanks

 

[Harlan Grove]

...
...

There are no formulas or calculations being performed. I'm
just displaying data from a cell in another spreadsheet.

...

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.

 

[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.

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

 

[Harlan Grove]

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"

The only thing I can think of is copying the cell containing the formula
that's working, pasting into the cell containing the formula that isn't,
seeing if the two results are then the same, and if so editing the pasted
formula so it's referring to cell $C$74 rather than $C$75. If that works,
good, but I'd have no idea what wasn't working before. If pasting the
formula gives an error, in which case the exact same formula would be in
different cells but evaluating differently, then Excel would be fubar and a
reinstall would be my only suggestion.