In this video I explain how to refresh pivot tables automatically when the source data changes. This solution uses a simple VBA macro and the Worksheet Change event.
The Worksheet Change event macro runs every time a change is made to a worksheet. We can use this macro on the sheet that contains the source data to make sure our pivot tables are refreshed whenever the source data is modified or updated.
I also share an alternative to the macro. We can enable the Pivot Table option: “Refresh data when opening the file” That option will only refresh the pivot tables when the file is opened by the user. It will NOT refresh the pivot tables when changes are made to the source data. For that to happen we need to use the macro solution.