|
Linking workbooks
Hey Gang,
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.
|