B
bkube01
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
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