How To Refresh A Pivot Table In Excel In Just Seconds

Refreshing a pivot table in Excel is simple either manually or automatically. Just a few clicks, and then we’re good.

What is a Pivot Table?

A pivot table is an essential Excel function that allows users to arrange and summarize complex data quickly.

This feature allows users to group their data by columns, sort it by values, and calculate statistics.

In addition to that, pivot tables are very useful when you have a large quantity of data.

Now that we already have an understanding of the pivot table, let’s finally move on to the tutorial on how to refresh a pivot table.

Refresh a Pivot Table in Excel Manually

Refresh a Pivot Table Automatically

Aside from manually refreshing a pivot table, you can also automatically refresh it. Here’s how:

Step 1: Click the PivotTable, then click the PivotTable analyze tab.

After clicking the analyze tab, click the PivotTable, then options.

Step 2: Upon clicking Options, a PivotTable Options dialog box will appear.

What you’ll do is click the Data tab, check the “refresh data when opening the file” checkbox, then click OK.

Now, every time we open the file, the pivot table will automatically refresh.

Conclusion

In conclusion, refreshing a pivot table in Excel is an easy thing to do. You just follow the simple steps in this tutorial, and you’re good.

I think we’re done with this article. I hope you’ve learned something from this. Do not forget to share this with your friends.

If you have any questions or suggestions, please leave a comment below.

What is new for PivotTable refresh in 2026

The 2026 Excel channel update added a subtle refresh status indicator in the bottom-right of the status bar. When a PivotTable is refreshing, a small spinner appears next to the sheet count. This helps confirm that a Refresh All command is still running on large workbooks with 10+ PivotTables, where earlier versions gave no visual feedback.

Excel for the web (browser) now supports manual refresh of PivotTables built on an Excel Table source. Click PivotTable Analyze > Refresh in the browser version, and the PivotTable rebuilds from the updated table. PivotTables connected to external data (SQL, Power Query) still require Excel desktop for refresh.

Common refresh problems

• Refresh does nothing. The source range is fixed and new rows are outside it. Go to PivotTable Analyze > Change Data Source and expand the range, or convert the source to an Excel Table (Ctrl T) so it grows automatically.
• Calculated field returns an error after refresh. The calculated field references a column that was removed or renamed in the source. Open PivotTable Analyze > Fields, Items, and Sets > Calculated Field and update the formula.
• OneDrive-hosted file does not refresh. Excel for the web supports table-based refresh but not external data. Open the file in Excel desktop, refresh, save, and the OneDrive copy updates.
• Refresh All is slow on large workbooks. Multiple PivotTables that share the same source can be linked with Use an external data source and rebuild only the shared cache. In Excel Options > Advanced > Data, tick Disable undo for large PivotTable refresh operations to speed things up.

Automating refresh with VBA

To refresh every PivotTable in the workbook automatically when a worksheet is activated, right-click the sheet tab, choose View Code, and paste:

Private Sub Worksheet_Activate()
    ThisWorkbook.RefreshAll
End Sub

Save the workbook as .xlsm (macro-enabled) for the code to run.

Quick step-by-step summary (click to expand)

1. Click inside the PivotTable Click any cell inside the PivotTable to activate the PivotTable Analyze tab on the ribbon.
2. Refresh a single PivotTable Click PivotTable Analyze > Refresh, or press Alt F5 as a shortcut. The PivotTable pulls the latest source data.
3. Refresh all PivotTables at once Click PivotTable Analyze > Refresh > Refresh All, or press Ctrl Alt F5. Every PivotTable in the workbook updates.
4. Enable auto-refresh on file open Open PivotTable Analyze > Options, go to the Data tab, and tick Refresh data when opening the file. Click OK.
5. Verify the refresh completed Check the corner cell of the PivotTable. Any new rows in your source appear immediately after a successful refresh.