Linking workbooks

[Ivan B]

I'm trying to link 2 workbooks with a "=SUMIF" formula and it won't find the source workbook. The path apears to be correct, both are on the same drive (shared drive) and I even tried putting both in the same subdirectory. It works if I open both, even if I minimize the source workbook. Why won't it find the workbook through the path without it being open?

 

[Bill_Biggs]

Can I see your code?

Display your code. I have a lot of experience in this area. It is almost always a code issue.

 

[Ivan B]

Thanks Bill, here it is

=SUMIF('U:\Cheese Data\[Cheese Data 2007.xls]Cheese'!$C6,$B$4,'U:\Cheese Data\[Cheese Data 2007.xls]Cheese'!K6)

 

[Bill_Biggs]

I was afraid of that.

Excel Spreadsheet function are limited to what data is open and available on the desktop. In order to do what you want done, you will have to either open the workbook with the data you want, or create a macro that will open the book. allowyour worksheet to grab the data it needs, and then reclose that book.

 

[Ivan B]

Thank you for your help

Appreciate your time