Why does my Excel PivotTable still show the old totals after I corrected the source rows?
TechnologyI corrected several quantities in our stock sheet, but the PivotTable summary still shows yesterday's totals. My colleague wants to type the expected totals straight into the summary so we can finish the handover.
The corrected records are existing rows within the selected source range. Microsoft documents refreshing PivotTable data and notes that automatic-refresh behaviour varies by Excel version and setup. Microsoft's refresh guidance
I'd rather understand the mismatch before sending the file. What would you check first, and what should we tell the next person about keeping this summary current?