Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallIf an Excel PivotTable is stale, omits new rows, shows Count instead of Sum, or displays an unexpected percentage, first compare its result with a small check of the source rows. Then work through the likely cause: refresh status, source range, source values, calculation settings, formulas, or an upstream query. Refreshing alone will not fix a wrong source range or calculation.
Start by matching the symptom to the likely cause
| What you see | Check first | Likely source |
|---|---|---|
| Old totals after changing source cells | Refresh the PivotTable | Stale report |
| New rows or columns are missing | Source range, Excel table, or connection | Source boundary |
| Count appears instead of Sum | Blanks, text, and mixed data types in the value column | Source values or summary function |
| Values look like unexpected percentages or proportions | Show Values As | Display calculation |
| Only particular categories or totals are wrong | Calculated fields or items | PivotTable formula |
| A query-backed report errors or refreshes incorrectly | Power Query output and error steps | Upstream data or query |
Excel separates the source data, the aggregation used to summarize it, and the way results are displayed. Identifying which layer is wrong helps avoid rebuilding a report when a refresh or one setting would do.
As an Amazon Associate I earn from qualifying purchases.
1. Refresh the PivotTable
When source cells have changed but the PivotTable still shows old results, select a cell in the PivotTable and choose PivotTable Analyze > Refresh. In some Excel versions the tab may appear as Analyze. To update multiple reports, use Data > Refresh All. Exact ribbon labels can vary by Excel version and platform. Microsoft’s guidance on refreshing PivotTables also covers refresh-on-open options.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Refresh pulls in changes from the current source; it does not fix an incorrect source boundary, a text value that should be numeric, or an unintended summary setting. Microsoft notes that its newer Auto Refresh feature for local workbook data is available to Microsoft 365 Insider participants, so do not assume every installation updates a PivotTable automatically.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
2. Check the source range or connection
If recently added rows or columns do not appear, inspect the PivotTable’s source. Select the PivotTable and choose PivotTable Analyze > Change Data Source (the tab name can vary). Confirm that the selected table or range includes the data you expect, or check that the correct external connection is selected. Microsoft explains the available source options in its guidance to change the source data for a PivotTable.
- If the source is an Excel table: added table rows can be included after refreshing, and added columns can become available in the field list.
- If the source is a plain range: the PivotTable may still point to the old fixed range, so change the source to include the new rows or columns.
- If the source is external: verify the selected connection and whether the external source itself contains the new data.
Microsoft’s instructions for changing source data describe adjusting the existing source. A substantially changed layout may be better handled by a new PivotTable, but check the range or connection first.
3. Check text, blanks, and mixed types in value columns
If a field you expect to total appears as Count, inspect the source column before changing its display format. Excel commonly defaults numeric values in the Values area to Sum; text or nonnumeric entries and blanks can lead to Count instead. A column that looks numeric can contain numbers stored as text or inconsistent entries. Microsoft describes these behaviors in its PivotTable value field guidance.
- Find the source column used by the value field and inspect entries that differ from the rest, including blanks and numbers stored as text.
- Correct the source values as appropriate; changing a number format alone does not convert text into numeric data.
- Refresh the PivotTable and check whether the intended result appears.
4. Set the intended summary function
When the source is suitable but the result still uses the wrong aggregation, open Value Field Settings for the affected field and review Summarize Values By. Choose the intended function, such as Sum, Count, Average, Min, or Max. Microsoft explains the available summary functions. The choices depend on the source type, and summary-function changes are not available for OLAP sources. The field label in the PivotTable may change with the selected method.
5. Check “Show Values As” separately
A value field can use a correct aggregation and still display an unexpected result if Show Values As transforms it into a percentage of a row, column, or grand total, or another custom calculation. Review that setting separately from Summarize Values By. Microsoft lists these display calculations in its PivotTable value calculation guidance.
If you need both the ordinary summary and a transformed view, add the same field to the Values area twice, then set the second copy’s Show Values As option.
Rank #4
6. Review calculated fields and calculated items
If only particular totals or categories look wrong, check whether the PivotTable uses a calculated field or calculated item. These are different kinds of PivotTable calculations. For a non-OLAP PivotTable, Microsoft documents List Formulas as a way to view formulas used in the report and explains calculated fields and items.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsPivotTable formulas have their own rules: they do not use ordinary worksheet cell references or defined names in the same way as worksheet formulas. If the displayed result conflicts with expectations, inspect the formula and the field or item it refers to before changing the source data.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.7. Inspect Power Query output and errors
If the PivotTable is based on a Power Query result, check the query output before treating the PivotTable as the source of the problem. Microsoft identifies incompatible data types as a possible cause of data-source errors—for example, when a numeric operation is applied to a nonnumeric type. A pivot-column operation can also error if a refresh unexpectedly returns multiple values where one was expected. See Microsoft’s guidance on handling data source errors in Power Query.
- Open the query that supplies the PivotTable and inspect its output and error steps.
- Correct the incoming data or query transformation that produces the error.
- Refresh the query output, then refresh the PivotTable.
8. Account for an OLAP or Data Model source
Not every PivotTable exposes the same calculation controls. With OLAP sources, values may be precalculated on a server; users cannot freely change some summary functions or add calculated fields and items as they can with ordinary worksheet data. If a control is missing, confirm the PivotTable’s source type rather than assuming the command is hidden. Microsoft’s guidance covers calculation options for PivotTables and notes that available options depend on the source. For a calculation controlled by the model or server, contact its owner.
9. Rebuild only if the source structure changed substantially
If source columns were added, removed, or substantially rearranged, first see whether changing the existing PivotTable’s source is enough. If the structure has changed significantly, Microsoft advises considering a new PivotTable. Rebuilding is a targeted option after checking the source range or connection—not the first remedy for a stale result or a single incorrect calculation.
Recommended Free Tools
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
