#N/A when linking to another Wb

[JAVB]

I have a series of formulas in workbook (Wb1) extracting data from
another workbook (Wb2). The data in Wb2 is text. The forumula in Wb 1
looks like this:

=IF('G:\Common\Back Office Pride\TSBO1\[TSBO1 Master.xls]Team
DVR'!$C24= 0, "", 'G:\Common\Back Office Pride\TSBO1\[TSBO1
Master.xls]Team DVR'!$C24)

When Wb2 is closed the formuals in C23, C25 and B24 all return the
correct text data but the formula in C24 returns #N/A .

When Wb2 is opend C24 returns the correct information.

If I key other data in C24, save and close it and then open Wb1, the
data in C24 will be correct but another cell will have the incorrect
data in it. By playing with the data in the cells in Wb2 I can get all
the data to appear correctly, but a few hours or days or months later
some random cell will again begin returning #N/A.

I have tried for months to figure this out but have been unable to do
so.

Has anyone seen anything similar to what I have tried to discribe?

Any help would be greatly appreciated.

Jeff

 

[Dave Peterson]

First, I've never seen anything like this.

Second, what's in C23:C25 and B24 of Team DVR in that workbook? Are you sure
it's not a formula that returns an error?

If those cells do contain formulas, then maybe posting a typical sample would
help.

And one more thing to try when you get this problem again:

Select the range of cells that have formulas pointing back to that other
workbook.
Edit|Replace
what: =
with: =
replace all

Maybe it'll be enough to wake up excel's recalculation engine.

I have a series of formulas in workbook (Wb1) extracting data from
another workbook (Wb2). The data in Wb2 is text. The forumula in Wb 1
looks like this:

=IF('G:\Common\Back Office Pride\TSBO1\[TSBO1 Master.xls]Team
DVR'!$C24= 0, "", 'G:\Common\Back Office Pride\TSBO1\[TSBO1
Master.xls]Team DVR'!$C24)

When Wb2 is closed the formuals in C23, C25 and B24 all return the
correct text data but the formula in C24 returns #N/A .

When Wb2 is opend C24 returns the correct information.

If I key other data in C24, save and close it and then open Wb1, the
data in C24 will be correct but another cell will have the incorrect
data in it. By playing with the data in the cells in Wb2 I can get all
the data to appear correctly, but a few hours or days or months later
some random cell will again begin returning #N/A.

I have tried for months to figure this out but have been unable to do
so.

Has anyone seen anything similar to what I have tried to discribe?

Any help would be greatly appreciated.

Jeff

 

[JAVB]

The formulas in C23:C25 and B24 are the same as in C24 with the
exception of the cell name. They are returning the correct data.
Jeff