nested IF SUMPRODUCT updating to closed workbook
 

Hello,

After viewing other postings, I understood SUMPRODUCT updates to closed
workbooks. So I replaced SUMIF with the below working formula.

I still have to update the file link values in order to populate with the
closed workbook's values.

Is there a way to update to the closed workbook without having to manually
edit/update file link values? (fyi - the file contains links to numerous
workbooks)

=IF(BB261=1,BC86,SUMPRODUCT(--('Q:\Office
Records\Finance\Forecast\2007\11+1\Debt
Files\[2008-1.xls]Forecast'!$D$6:$Z$6=BA262),--('Q:\Office
Records\Finance\Forecast\2007\11+1\Debt
Files\[2008-1.xls]Forecast'!$D$5:$Z$5=BA261),--('Q:\Office
Records\Finance\Forecast\2007\11+1\Debt
Files\[2008-1.xls]Forecast'!$D$105:$Z$105)))

Appreciate your advisement,
Sharon