Refresh PivotTable

When source data changes, the PivotTable may need to be refreshed.

Refresh

Right-click PivotTable → Refresh

Or:

PivotTable Analyze → Refresh

Refresh All

Use:

Data → Refresh All

when multiple queries/connections/PivotTables need updating.

PivotTable Options

Important settings include:

  • Layout & Format
  • Totals & Filters
  • Display
  • Printing
  • Data
  • Preserve cell formatting
  • Autofit column widths
  • Show/Hide field headers
  • Repeat item labels

Practice

Add new sales records to the source data and refresh the PivotTable

PreviousNext