US Trends

how to refresh a pivot table

To refresh a PivotTable, click anywhere inside it, then use the Refresh command or a shortcut so it pulls in the latest source data.

Quick Scoop: How to refresh a Pivot Table

1. Fastest manual refresh

  • Click any cell inside your PivotTable.
  • Go to the PivotTable Analyze (or Analyze / Options in older Excel) tab on the ribbon.
  • Click Refresh in the Data group.
  • Or right‑click inside the PivotTable and choose Refresh.

This tells Excel to reread the source data and update all the numbers and totals.

2. Keyboard shortcuts

  • Refresh the active PivotTable: press Alt + F5.
  • Refresh all PivotTables in the workbook: press Ctrl + Alt + F5.

These shortcuts are handy when you’re working on reports and need quick updates again and again.

3. Refresh all PivotTables at once

If your workbook has multiple PivotTables:

  • Go to the Data tab or PivotTable Analyze tab.
  • Click Refresh All.

This updates every PivotTable and any connected queries in one shot.

4. Auto‑refresh when opening the file

To avoid forgetting to refresh:

  1. Click inside the PivotTable.
  1. Go to PivotTable Analyze → Options.
  1. In the PivotTable Options dialog, open the Data tab.
  1. Check Refresh data when opening the file and click OK.

Next time you open the workbook, the PivotTable refreshes automatically from its data source.

5. Example: when you add new rows

Imagine you track sales in a table and use a PivotTable to summarize by month.

After adding new sales rows, the PivotTable won’t change until you Refresh or Refresh All , or until the file reopens if you turned on auto‑refresh.

TL;DR:
Click inside the PivotTable → use Refresh (or Alt + F5) to update it, or Refresh All / “Refresh data when opening the file” if you have many PivotTables or want automatic updates.