I have linked to data from another workbook, which I do by just clicking on the cells I want on the other workbook as if it were a different sheet and it fills in the necessary reference info. Usually my spreadsheet will read from the linked workbook even if it's closed. I have one spreadsheet that requires me to open the other workbook. What makes it need to have the linked source open or allow it to stay closed? How can I make this one link with the other workbook closed? I'm using 2007.
not all functions work with closed workbooks, maybe that's your problem?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It's possible that could be it. I'm using the countifs function in this particular case. Where would I find a list of functions that need to have it open?
yes, countifs only work on open workbooks
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
see here for a work around
http://support.microsoft.com/kb/260415
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks