Automatic updating pivot table
To do this: Note that if you change the data source into an Excel Table and then use the Excel table to create the Pivot Table, you don’t need to use the change data source option.
You can simply refresh the Pivot Table and it’ll account for the new rows/columns.
For refreshing your Pivot Table or update Pivot Table you need to refresh your Pivot Table every time you open the Pivot table document.
Lets look at some ways we can refresh all, or chosen Pivot Tables.
The code below here can be called (Run) via the Worksheet_Activate Event.
Read this post if you'd rather refresh your pivot table when you activate pivot table worksheet.
Here is instructions on how to insert the event code to your "pivot table data source" worksheet: Your pivot table is now instantly refreshed whenever a cell value on worksheet "Data" has changed, and the pivot table source data range is adjusted if values have been added/deleted to your excel defined table.