Excel How-to
Pivot Table Not Refreshing in Excel: New Rows, Cache, and Data Source
Fix a pivot table that will not pick up new rows or still shows old totals. Covers a range that is too short, Refresh vs Refresh All, filters, and the Google Sheets equivalent.