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.