I have a formula that links using SUMIF to other workbooks.

When I close the target workbook the formula returns The Value Error

I have tried entering this as an array also and it doesn't work - any ideas?

=SUMIF('S:\Finance\CFM\Actuals\Month\2006\1 January
2006\[FAL_Variance_Det_by_AC_v_BUD 170206.XLS]Output 1
(0303)'!$1:$65536,"Total Expenses",'S:\Finance\CFM\Actuals\Month\2006\1
January 2006\[FAL_Variance_Det_by_AC_v_BUD 170206.XLS]Output 1 (0303)'!$B:$B)