If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Having a small problem with linking workbooks. Here is the formula below
=SUMIF('H:\Host File\Events Attended\09-10\[Events Attended List March09-March10.xls]LIST'!$B$2:$B$2000,B9)
The problem is this: When the workbook that it is linked to, when i close it i get a VALUE error. But when i reopen it it works fine?? I need it to work regardless of open or close.
Any help would be greatly appreciated.
Thanks
Mikey
Last edited by mikeydaman; 07-04-2009 at 05:49 PM.
Linear Mode
