One way to automatically refresh is to set the pivot table to refresh when you open the file that it’s in. You have to remember to do this, every time the data changes! Pro: This is a simple way to instantly refresh the pivot tableĬon: It’s not automatic. Right-click any cell in the pivot table, then click on Refresh.No, this isn’t automatic, but a quick and easy way to refresh the pivot table after the data changes is to manually update it: Change a pivot table setting, to get some automatic updates.Use a macro to automatically refresh an Excel pivot table.There isn’t any setting the you can change, to make Excel automatically refresh a pivot table, as soon as the data changes.Īs a result, to keep the pivot table up-to-date, you have 3 choices: If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised data right away. No Built-In Automatic Refresh for Pivot Table However, here are 3 ways you can refresh a pivot table, after you make changes to the source data. Unfortunately, there isn’t a built-in way to make that happen. It would be nice to automatically refresh an Excel pivot table, whenever its source data changes.