Want to know more on Pivot tables automatic update.

Hello Bamfoa,

Thank you for your question. To set Pivot Tables to refresh automatically, you need to enable the auto-refreshing feature by right-clicking any cell in the pivot table and choosing PivotTable Options from the context menu.

From the PivotTable Options window, go to the Data tab and check the Refresh data when opening the file option.

Each time you open the file with the Pivot Table(s), it will refresh all Pivot Tables in that file automatically.

I hope this helps.

Kind regards
Marius Barnard
STL