How to Refresh a Pivot Table in Excel

This article will demonstrate how to refresh a pivot table in Excel.

 

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.