Links only work with both workbooks open...

[Paul]

I have read some previously posted questions about links between workbooks
not functioning unless both are open, but my problem is a bit different.

I have one workbook which links (calls upon) another workbook. The link
doesn't involve text, but rather database-type functions (specifically DSUM).
Here is what the requesting workbook contains in the linked cells:

=DSUM('C:\[Organizing 2004.xlsx]2004 Jobs'!$A$4:$W$568,"$$$",'C:\Data &
Criteria.xlsx'!Feb)

In effect, this cell goes to the workbook c:\organizing 2004.xlsx, sheet
Jobs_2004, looks in a table (the cell range a4:w568), and under the $$$
column it totals any values that occurred during the month of Feb (it gets
the value for Feb from the workbook Data & Criteria.xlsx).

So this one formula actually references two workbooks.

This works great as long as the two other workbooks are open, but won't hack
it otherwise (gives the VALUE error).

Maybe you can't call upon two at once unless they're both open?? Or any
other thoughts?

 

[JLatham]

Certain worksheet functions will not work across workbooks unless the
"foreign" book is open also. It isn't the fact that you're referencing
multiple foreign workbooks, but the function that's being used that is
causing this to work this way.

 

[Paul]

Bummer...

Thanks for the response
--
Paul

Certain worksheet functions will not work across workbooks unless the
"foreign" book is open also. It isn't the fact that you're referencing
multiple foreign workbooks, but the function that's being used that is
causing this to work this way.

I have read some previously posted questions about links between workbooks
not functioning unless both are open, but my problem is a bit different.

I have one workbook which links (calls upon) another workbook. The link
doesn't involve text, but rather database-type functions (specifically DSUM).
Here is what the requesting workbook contains in the linked cells:

=DSUM('C:\[Organizing 2004.xlsx]2004 Jobs'!$A$4:$W$568,"$$$",'C:\Data &
Criteria.xlsx'!Feb)

In effect, this cell goes to the workbook c:\organizing 2004.xlsx, sheet
Jobs_2004, looks in a table (the cell range a4:w568), and under the $$$
column it totals any values that occurred during the month of Feb (it gets
the value for Feb from the workbook Data & Criteria.xlsx).

So this one formula actually references two workbooks.

This works great as long as the two other workbooks are open, but won't hack
it otherwise (gives the VALUE error).

Maybe you can't call upon two at once unless they're both open?? Or any
other thoughts?