Pivot table not updating with new data
This action is the same as if you manually click the Refresh button on the Data tab.
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.
So I have a pivot table with a data source internal in the workbook just a different sheet but it's not updating/refreshing whenever i click refresh nothing happens.
I really need to modify my data source with a different sheet or different range just to update the pivot.
That will add a Worksheet_Selection Change event to the module, which we don’t actually want, so we will delete it in just a moment.
Before we do, let’s go to the Procedure drop-down menu on the right and choose Change.