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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Linking workbooks
- Thread starter Ivan B
- Start date
Bill_Biggs
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 1,216
Can I see your code?
Display your code. I have a lot of experience in this area. It is almost always a code issue.
Display your code. I have a lot of experience in this area. It is almost always a code issue.
Upvote
0
Bill_Biggs
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 1,216
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.
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.
Upvote
0
