Auto updating pivot table
I also share a non-macro solution to update the pivot tables when the file is opened. Skill Level: Intermediate If you learn best by doing it on your own, you can download the file I'm using in the video to follow along. Refresh Pivot Table (41.5 KB)Can your pivot tables be updated immediately and automatically when their source data changes? It requires the use of a really simple macro that I will show you how to create below.
If you’re not too familiar with macros and VBA, I suggest checking out my free 3-part video series on getting started with Macros & VBA.
VBA: Auto refresh the specified pivot table with the name of the specified pivot table. From now on, when you change the data in the source data, the specified pivot table will be refreshed automatically.
Within the code module, we want to create an event macro.