In this tutorial, you will learn how to refresh a pivot table in Google Sheets.
Pivot tables are a powerful tool for summarizing data, finding patterns, and reorganizing information, so it’s no wonder that many people use them. A common question when working with pivot tables is how to refresh them. The simple answer is that you don’t need to. Google Sheets pivot tables refresh any time you change the source data. So you’ll rarely have to worry about refreshing them.
Of course, things don’t always work exactly how they should. If your pivot table isn’t refreshing, there are a few things you can try
Refresh the Page
As with any website, Google Sheets can need a quick refresh. Simply hit the refresh button on your browser, wait for the page to reload, and your pivot table is likely to refresh
Ensure New Data is In Range
Another reason a pivot table may appear to not be updating properly is if new data has been added after the end of the range. In the following image, the original pivot table range is outlined, and a new data row has been added after it
When we check the associated pivot table, the new item SKU 9999 is not visible because this line is not included in the pivot table
If you run into this problem, here’s how to correct it:
Click on any cell in the pivot table and the Pivot Table Editor will open
At the top of the editor is the pivot table data range. Edit the range to include the newly added row(s). For example, if the original range was data!A1:E16 and you added 1 additional row, you can update the range to data!A1:E17
The pivot table will immediately update to include the new row(s)
The last thing to check if the pivot table isn’t updating is that filters haven’t been applied. If filters are applied, new items may not appear in the pivot table. For example, if you apply a filter to the ITEM SKU column so that only rows with certain SKUs display, if a new SKU is added, rows with that SKU will be hidden by default.
If this happens, the best way to correct it is to delete the existing filter or filters that are causing the problem and recreate them as you needed. Here’s how:
Open the Pivot Table Editor, scroll to the list of filters at the bottom, and click on the X beside each filter you want to delete. Start with the filters most likely to be causing the problem. These will be the ones filtering on fields that have new values in the newly added data
When you’ve deleted the problem filters, all the new values should appear in your pivot table
You can recreate filters by clicking Add and creating a new filter
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to refresh a pivot table in Google Sheets. Want more? Check out all the Google Sheets Tutorials.