Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links only work with both workbooks open...
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? -- Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links only work with both workbooks open...
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" wrote: 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? -- Paul |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links only work with both workbooks open...
Bummer...
Thanks for the response -- Paul "JLatham" wrote: 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" wrote: 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? -- Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
links to a second workbook doesn't work if origin not open | Excel Worksheet Functions | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
Making links between workbooks work | Excel Discussion (Misc queries) | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) |