A pivot refreshes when its source cells change, but it cannot summarize records outside its selected input. Check the data range before looking for a generic refresh button.
Compare the input boundary
Open the pivot editor and inspect Select data range. Find the last expected record in the source and confirm its row lies within that range.
Look for new columns as well as new rows. An appended measure or renamed field may require configuration changes beyond extending the bottom boundary.
Review filters and categories
Extend the source range deliberately, retaining the correct header row and excluding unrelated totals. Then inspect the pivot’s filters. Google notes that value-based filters preserve their selected values and may need updating to show newly introduced categories.
A new record can therefore be inside the source range but still excluded by a legitimate filter. Distinguish range omission from filter exclusion before changing either.
Verify the added population
Check a known new record’s group and compare before-and-after totals. Include a newly introduced category and a new record in an existing category. Use supporting-row details when necessary.
Do not manually paste new results into pivot output, which can leave a static or conflicting report. Document how the source grows and review the range after the normal import process. Choosing an excessively broad range can add unnecessary work or unrelated records, so use a maintained boundary appropriate to the dataset. Check charts based on the pivot separately: a corrected summary does not establish that a downstream chart includes newly added rows or categories in its own range.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.