Fix – MS Excel – Cause PivotTable to Refresh When New Data is Entered
Right Click on your pivot table report tab
Select the view code menu item
Add the code snippet below (assuming that the Pivot Table is the first or only pivot table on the page) in the box
Click on the Save button at the left of the window
Close the code window.
Every time you click on the worksheet tab, the table will refresh.
Private Sub Worksheet_Activate()
I was helping my brother in law work on a master spreadsheet that listed the various jobs that were being worked on. I created two pivot tables that filtered the jobs by the person who was working on it. However, when the master list was updated, the pivot tables were not refreshing. To work around it, he was exiting and then opening the file again. Yuck!
What is Happening
The bit of code is telling the first pivot table on the worksheet tab to update when the worksheet is accessed (i.e. activated).