Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Why does my Excel PivotTable still show the old totals after I corrected the source rows?

Technology category photographTechnology

I 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?

Discussion

5 community replies

Don't create a second set of authoritative totals by typing what you expect over the summary. Keep the corrected source records, save a copy if needed, and investigate how the PivotTable is being updated. Otherwise the handover will conceal the unresolved link.

Try the PivotTable's Refresh action and compare one affected item with its source records. Microsoft's instructions provide manual refresh as well as options for refreshing when a workbook opens. Pick the behaviour you can confirm in your actual Excel version.

The colleague's urgency is understandable. A useful interim message would identify the source as corrected and the summary as awaiting verification. That is clearer than sending a polished-looking total that nobody can explain.

If refreshing doesn't produce the expected result, inspect the selected data source and the PivotTable's filters and field arrangement. Start with one known corrected item; don't change several settings at once and lose the trail.

Include whether that item should be present under the current filters. A mismatch can come from comparing different sets of records, even after a refresh. The check needs an agreed set of rows, not just two numbers that look as though they ought to match.

Join the discussion

More in Technology