Formula guide · Excel and Google Sheets · Updated May 13, 2026
Pivot Table Not Refreshing
Fix pivot tables that do not show new rows, changed values, or updated source data.
Quick Answer
If a pivot table does not refresh, check the source range first, then refresh the pivot and verify filters.
Copyable Formula
Use a table or named range so new rows are included automatically.Syntax
Refresh the pivot table and confirm the source range includes the new data.Excel and Google Sheets
Worked Example
| Symptom | Likely cause |
|---|---|
| New rows missing | Source range too small |
| Values unchanged | Pivot not refreshed |
| Rows hidden | Filter still active |
Result: Most refresh issues are caused by source ranges or active filters.
Steps
- Confirm the new rows are inside the pivot source range.
- Refresh the pivot table.
- Clear filters and check grouped dates if totals still look wrong.
Common Mistakes
- Adding data below a fixed range without expanding the source.
- Assuming refresh also changes the source range.
- Not checking filters before rebuilding the pivot.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.