How to Refresh Data in Pivot Table

In this Excel tutorial, you will learn how to refresh pivot table with new data. You need this to analyze the data after the update.

Pivot Table data preparation

1. Click any cell in with in the pivot table.

refresh pivot table data

2. After clicking the cell, pivotable tools will appear in the tool bar. Click analyze under pivottable tools.

Refreshing pivot table analyze tab

Refreshing pivot table data

3. Now, click refresh to refresh your data in the pivot tables. This will refresh the data in the pivot table with the latest data in the source range.

Note: For large pivot tables, it may take a long time.

4. To have refreshed data by default, go to PivotTable Options and tick the "Refresh data when opening the file" option.

refresh pivot table

Note: This option is useful to always work with fresh data. However, you may think about unticking this option when you are opening the huge datasets many times a day. Refreshing may be a major part of your workday.

If you want to refresh the data automatically whenever the source data changes, you can use the "Refresh Every" option. To do this, go to the "Data" tab in the Excel ribbon, and then click "Options." In the "Data" section, select "Refresh Every" and specify the time interval that you want Excel to refresh the data.

If the pivot table data is not being updated as expected, it may be because the source data has changed. In this case, you can update the source data range for the pivot table by right-clicking on the pivot table and selecting "Change Data Source." Then, select the new data range and click "OK."