Sumproduct wont update properly on closed workbooks

[vane0326]

Hello


I would like to know if anyone ran into this problem before.

I have a workbook template that has built in formulas functions that
are capable of closed workbooks. The formulas do a monthly
summarization retrieving values from multiple workbooks. In cell C3 I
input the starting date and E3 I input the ending date.


Now here is the problem. When I input the starting date and ending
date, the values will not update properly there are totals but there
are incorrect. I would have to double click the cells that house the
formulas manually and hit enter and then it will update.

Here is one of the formulas I'm using.

=SUMPRODUCT(('S:\Data\[Systems.xls]System
1'!$B$2:$B$40000>=C3)*('S:\Data\[Systems.xls]System
1'!$B$2:$B$40000<=E3)*('S:\Data\[Systems.xls]System 1'!$N$2:$N$40000))

I checked to make sure that the Calculation is on Automatic and it is.
Also I tried to update the links but it won’t update properly. Like I
said before it won’t update properly unless I double click each cell
and hit enter.


If anyone has any suggestion please let me know, if it’s a vba or just
a settings issue.


Please let me know.