Quick answer
A PivotTable may need refreshing after source data changes. Refresh the report, then check whether its source range actually includes the new records. A refresh cannot add rows outside a fixed range.
Understand the problem before changing anything
An old total can come from stale data, an unchanged source range, active filters or a query that has not finished. These are different problems, so check each in order rather than recreating the PivotTable immediately.
Step-by-step checks
Confirm the source change
Find a new record or changed amount that should affect the result. Record its expected category and value for comparison.
Refresh the PivotTable
Right-click within it and select Refresh, or use the PivotTable ribbon command. Wait for any related data connection to complete.
Inspect the source definition
Check Change Data Source or the connection used by the PivotTable. Extend a fixed range if the intended rows fall outside it.
Review filters and queries
A slicer or report filter can hide newly added data. If a query feeds the source table, refresh that query and confirm it loaded successfully.
Test an expandable source
An Excel table can make recurring row additions easier to manage. Confirm the PivotTable uses the table, then refresh and reconcile the totals.
What to avoid
Automatic refresh behaviour varies by Excel version and source. Do not assume opening the file or editing a cell refreshes every connected report.
How to verify the result
Locate your test record in the refreshed result and compare the grand total. Check the saved workbook again if other people depend on its last calculated values.
Check the workbook’s structure as well as the visible result
Work on a separate copy when the workbook supports invoices, stock, payroll or a shared report. A cell’s appearance is only one layer: its stored value, formula, number format and validation rule can differ. Record the affected worksheet and one example cell so you can compare the same case after each change.
Use a small, known example to test the intended behaviour. Check one ordinary row, one blank and one unusual value rather than judging a whole report from its grand total. If the workbook imports data, correct the import or source definition where possible; repeatedly correcting the final display can leave the same problem waiting for the next refresh.
Before sharing the result, check formulas that depend on the changed area and any charts or PivotTables fed by it. Save, close and reopen a working copy, then verify the same example. Mention any deliberate conversion of text, dates or identifiers so another user does not reverse it accidentally. If a colleague owns the workbook, agree changes to validation, protection and calculation settings rather than silently changing the model.
Before you finish
- Affected sheet and sample cell
- Original value compared with expected value
- Source, formula and display checked separately
- Dependent reports tested after saving
Common question
Why does Refresh finish without showing the latest row?
The row may be outside the source range, excluded by a filter or missing from an upstream query. Check the data path from source to report.
Need help with the next step?
Tell RJ Computers the device model, exact symptom, checks already tried and whether important files are backed up. Confirm availability, assessment charges and the scope of work before arranging a visit.
Reference and version notes
Check the official instructions for your exact product version; menu names and available features can differ.
Official product documentation