See all How-To Articles

How to Refresh a Pivot Table in Excel & Google Sheets

This article will demonstrate how to refresh a pivot table in Excel and Google Sheets


refresh intro


Refresh a Pivot Table

PivotTable Analyze Tab

Consider the following pivot table.


refresh pivot 1


Say you go back to your database and make some adjustments.


refresh data


If you switch back to the pivot table, it won’t have changed. To update the pivot table, refresh the data.

  1. Click in your pivot table.
  2. Then, in the Ribbon, select PivotTable Analyze > Refresh.


refresh ribbon


This will refresh the pivot table to include the updated figures.


refresh pivot 2


Refresh With the Quick Menu

  1. Right-click anywhere inside your pivot table to obtain the Quick Menu.


refresh quickmenu


  1. Select Refresh.

Change the Data Source

If you add any more rows or columns to the range that is selected as the data source, you need to update the data source to reflect these changes. Say, for example, the original range for your pivot table is B2:E81, but then you add more rows to the data.


refresh add rows


You would now need to change the data source of your pivot table to include these rows.

  1. Click within your Pivot table in order to show the PivotTable Analyze tab in the Ribbon.
  2. In the Ribbon, select PivotTable Analyze > Data > Change Data Source.


refresh data source


  1. Amend the range to include your additional rows.


refresh change source


  1. Click OK to refresh the pivot table.

Refresh All

If you have more than one pivot table or any other linked data in your workbook, you can refresh all the data with one click!

In the Ribbon, select PivotTable Analyze > Data > Refresh > Refresh all.


refresh all


This works for any changes made as long as none of the data ranges have been extended.

Tip: Try using some shortcuts when you’re working with pivot tables.

How to Refresh a Pivot Table in Google Sheets

As soon as you update the underlying data in a Pivot table in Google sheets, the Pivot table will automatically update.

You can manually change the data source if you wish to amend the underlying data range that the Pivot Table refers to.

printingproblems gs change source


See all How-To Articles