Matching across multiple workbooks
 

Hi,

I'm pulling data across multiple workbooks via the following formula:

=SUMIF('\\Fil-nw02-06\coc\CAM\Business
Systems\[BusSys_SPI-CAM-MatriX.xls]RawScores'!$B$2:$B$149,B13,'\\Fil-nw02-06\coc\CAM\Business
Systems\[BusSys_SPI-CAM-MatriX.xls]RawScores'!$E$2:$E$149)

When I open the workbook containing the above formula, the calculation
errors due to (I believe) the formula being too long. If I open the
source workbooks first, the calculation works properly. Does anyone
know of a way to around these errors? Any help would be appreciated.
Thanks.

Brian


--
bkube01
------------------------------------------------------------------------
bkube01's Profile: http://www.excelforum.com/member.php...fo&userid=9583
View this thread: http://www.excelforum.com/showthread...hreadid=528624