Pivot table not updating with new data

Posted by / 04-Jan-2020 01:45

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.

pivot table not updating with new data-59pivot table not updating with new data-3pivot table not updating with new data-11

One thought on “pivot table not updating with new data”

  1. There are only 4 truly reliable affair dating sites. You’ll run the risk of being caught by a Private Investigator if you sign-up for ANY other affair dating site. If you only choose 2 sites (or just 1), Affairs should be one of them. You get to choose between a few women, or sleep with all of them. If you’re only signed up for one site, you probably won’t have more than 1-2 women at a time to choose from.