How to Refresh a Pivot Table in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on April 1, 2023

This tutorial demonstrates 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, go to PivotTable Analyze > Refresh.

 

refresh ribbon

 

This refreshes 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

 

To properly refresh the pivot table, first change the data source of your pivot table to include these new rows.

  1. Click within the pivot table to show the PivotTable Analyze tab in the Ribbon.
  2. In the Ribbon, go to PivotTable Analyze > Data > Change Data Source.

 

refresh data source

 

  1. Expand the range to include the 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, go to 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.

Refresh a Pivot Table in Google Sheets

You can manually change the data source that the pivot table refers to, but as soon as you update the underlying data in Google Sheets, the pivot table updates automatically.

 

printingproblems gs change source

AI Formula Generator

Try for Free

See all How-To Articles