Excel troubleshooting

Why Is My Pivot Table Not Updating?

Fix Pivot Tables that do not refresh, miss new rows, or show stale totals after the source data changes.

Problem

  • Pivot Tables stop updating when the source range does not include new rows, refresh has not been run, or the cache still points to old data.

Quick fix

  • Refresh the Pivot Table, expand the source range or convert it to an Excel Table, then rebuild if fields were renamed.

What to check

  • Click Refresh on the PivotTable Analyze tab after adding rows.
  • Confirm the source range includes blank rows only at the end, not in the middle of the dataset.
  • Convert the source data to a Table so new rows are included automatically.

Reliable fixes

  • Use Change Data Source to expand the range or point to a structured Table.
  • Remove and re-add fields if column headers changed.
  • Use Get Pivot Data carefully when linked formulas depend on the refreshed layout.

Frequently asked questions

  • Refresh vs Change Data Source? Refresh updates the cache. Change Data Source is needed when rows were added outside the original range.
  • Should the source be an Excel Table? Yes — Tables auto-expand and reduce stale pivot data when new rows are appended.
  • Pivot shows old month after new data? Refresh, then check filter fields and that the date column is recognized as dates not text.