Formula doesn't update itself

[Bandito1]

Hello all,

I use the following formula;

=IF(AS22="";"";SUMPRODUCT(--('\\nltilnetapsnas1\PUBLIC\Supply Chain\Planning\Sales Order Report\[Tracker QA on the floor New.xlsm]Tracker QA on the Floor'!$J:$J=AS22)))

I specific use SUMPRODUCT cause it should update even if the source file is closed.

It doesn't; i just opened the file and the data it showed was 0.
After i hit enter when i click the formula it updates.

The calculation options is set on automatic

Someone knows why the data doesn't update?

 

[Alex Blakenburg]

You might want to test it but if you right click on the query, you should be able to set it to refresh when you open your workbook. I have logged off for the day.
It doesn’t update when new data is loaded until you initiate a refresh.

 

[Bandito1]

So if i get it right;

I have to do; data -> get data -> from file -> from workbook each day?
Since the file is updated each day with data. The data is expanding each day

 

[Alex Blakenburg]

No right click in query select refresh. Similar to a pivot table refresh.