If an Excel PivotTable is not refreshing, right-click inside it and select Refresh; to update every PivotTable and connection, choose Data > Refresh All. If the result is still old, check whether the PivotTable’s source includes the changed rows, whether source formulas have recalculated, and whether an external connection finished refreshing.
Start with the quickest checks
First, make sure you refreshed the correct object. Right-click a cell in the PivotTable and choose Refresh, or select a PivotTable cell and use PivotTable Analyze > Refresh. If your workbook uses multiple PivotTables or imported data, run Data > Refresh All and allow any queries or connections time to finish.
Then check whether the change is present in the source data itself. Find the original worksheet, query output, or external file and verify that the edited value or new row is there. A PivotTable cannot display data it does not receive from its source. Also check for active report filters, slicers, or date filters that might be excluding the item you expect to see.
- Save the workbook after a successful refresh so the updated results are retained.
- If the refresh command is unavailable, confirm that you selected a cell inside the PivotTable.
- If only one PivotTable is stale, refresh that table first; if several are stale, use Refresh All.
How PivotTable refresh works
A PivotTable summarizes data from a source, such as a worksheet range, an Excel table, a database, or a query. For a standard worksheet-based PivotTable, Excel keeps a cached copy of source data. Refreshing tells Excel to read the source again and update the cache and summary. Until that happens, changing a source cell does not necessarily change the displayed PivotTable result.
Refreshing is different from recalculating formulas. If a source cell contains a formula, Excel must first calculate the new formula result; the PivotTable then needs to refresh to read that result. Similarly, a PivotTable may refresh successfully but still look unchanged if the source range is fixed, a filter hides the changed record, or the edited value does not affect the displayed summary.
For a PivotTable connected to an external source, refresh also depends on the connection. Excel may need to contact a database, update a query, or authenticate. In those cases, Refresh All can take longer than refreshing a local worksheet range, and an error or access problem may prevent updated records from arriving.
Check whether the source range includes new rows
A frequent cause is adding records below a fixed source range. For example, suppose a PivotTable was created from A1:D100, and new transactions are entered in rows 101 through 110. Refreshing the PivotTable reads the original range again; it does not automatically extend that range simply because data now appears below it.
To inspect or correct the source for a regular worksheet-based PivotTable, select the PivotTable and choose PivotTable Analyze > Change Data Source. Confirm that the range covers all records and columns, then refresh. This command is not the right remedy for every connection-based or Data Model PivotTable; those use their connection or model as the source.
For lists that grow over time, use an Excel table as the source. Select the source data and choose Insert > Table (or press Ctrl+T on Windows), making sure the header option is correct. A PivotTable based on that table can include rows added to the table when you refresh. On Mac, use Insert > Table; keyboard shortcuts can differ by keyboard and Excel settings.
Keep the source structured: use one header row, give every column a distinct nonblank heading, and avoid blank rows that split the records. A broken or incomplete source layout can make it harder to select the correct range and may cause fields to be missing or interpreted unexpectedly.
Recalculate source formulas before refreshing
If the source data includes formulas, check the calculation setting. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic if the workbook should recalculate formulas as inputs change. With calculation set to Manual, a source formula can continue showing its previous result until you recalculate, so the PivotTable may be faithfully summarizing an outdated value.
Press F9 to calculate formulas in open workbooks, then refresh the PivotTable. If ordinary recalculation does not update dependent formulas, Ctrl+Alt+F9 forces a full calculation. These steps address calculation, not the PivotTable source range: if new records fall outside the source, recalculating will not bring them into the summary.
Excel for Mac has calculation options under Formulas as well, though keyboard shortcuts can vary with the keyboard and macOS settings. In Excel for the web, available calculation and connection controls may differ from the desktop app. If a workbook depends on a desktop-only external connection, try refreshing it in Excel for Microsoft 365 on Windows.
Look for filters, grouping, and old labels
A refreshed PivotTable can contain updated data without showing the particular item you are looking for. Check the drop-down filters on row and column fields, report filters above the table, and any slicers or timelines. Clear filters temporarily to test whether the record is present. Also look at the value field: a change to one source record may be hard to notice when the PivotTable shows a total across many records.
Grouping can affect what appears. Dates grouped by month or year, for example, may show a month total rather than each date. A new date can appear within an existing group, so the visible labels may not change even though the total does. Confirm the detail by expanding the group or checking the underlying records.
In some standard PivotTables, old field items can remain in filter lists after they disappear from the source. This is not proof that the current summary is using an old record. To control retained items, right-click the PivotTable, choose PivotTable Options, open the Data tab, and inspect Number of items to retain per field. Setting it to None can clear obsolete labels after a refresh. The exact options available depend on the PivotTable’s source type.
Diagnose queries and external connections
If the PivotTable uses Power Query, a database, or another external source, refresh the query or connection as well as the PivotTable. Select Data > Refresh All, then check Data > Queries & Connections for connection status or errors. A query might fail because a file moved, a server is unavailable, credentials expired, or the connection no longer has permission to read the source.
When a query loads its results to a worksheet table, check whether that output table actually updated before troubleshooting the PivotTable. If the query output is stale, the PivotTable has no new data to summarize. If the query output is current but the PivotTable is not, refresh the PivotTable afterward and verify that its source points to the query output or the intended model.
Some connections refresh in the background, so the workbook may still be working after you click Refresh All. Wait for completion and check for status messages before judging the result. You can also inspect a connection’s properties from Data > Queries & Connections by opening its properties, where refresh-related options may be available. The options depend on the connection type; do not assume that every data source supports the same settings.
A reliable troubleshooting sequence
Use this order to isolate the cause instead of repeatedly refreshing without checking the source:
- Confirm the changed record or value exists in the actual source, not just in a different copy of the workbook.
- Check the source boundaries. For a worksheet range, make sure new rows are included; for a growing list, consider basing the PivotTable on an Excel table.
- Recalculate source formulas if necessary, then right-click the PivotTable and choose Refresh.
- Use Data > Refresh All if queries, connections, or other PivotTables are involved, and wait for completion.
- Clear relevant filters and inspect groups, field labels, and the value summary to see whether the updated record is hidden or rolled into a total.
- If the result remains wrong, check connection errors and confirm the PivotTable is based on the expected source. Save a copy before making structural changes to a complex workbook.
This sequence distinguishes three issues that can look alike: the data was not updated at its origin, the PivotTable is not reading the complete or current source, or the refreshed result is hidden by how the table is filtered and summarized.
Prevent the problem from returning
For a regularly updated report, use a well-formed Excel table as the worksheet source, keep its headers stable, and avoid adding records outside the table. If you need the PivotTable to refresh when the workbook opens, select a cell in it, open PivotTable Analyze > Options, go to the Data tab, and select Refresh data when opening the file, if that option is available for the source. This refreshes on opening; it does not make every edit update the PivotTable immediately while the workbook remains open.
For reports based on connections, document where the source lives and who can access it. Before sharing the workbook, refresh it and check that the displayed results are current. If the source is a file on another computer or a protected database, recipients may not be able to refresh it without the same path, access, or credentials.
Frequently Asked Questions
Why does my PivotTable show old data after I change a cell?
A PivotTable usually needs a refresh after source data changes. Right-click inside it and choose Refresh. If the source cell contains a formula, recalculate the workbook first; if the change is in a new row, check that the PivotTable source includes that row.
Why does Refresh not include the new rows I added?
The PivotTable may use a fixed range that ends before the new rows. Use PivotTable Analyze > Change Data Source to extend a regular worksheet source, or use an Excel table as the source so added table rows can be included on refresh.
What is the difference between Refresh and Refresh All?
Refresh updates the selected PivotTable. Data > Refresh All updates all refreshable PivotTables and data connections in the workbook. Refresh All is useful when a PivotTable depends on query output or several workbook objects need updating.
Can I make an Excel PivotTable refresh automatically?
You can select Refresh data when opening the file in the PivotTable Options Data tab when the option is supported by that source. This refreshes on workbook opening, not continuously after every source edit.
Why does a PivotTable still look unchanged after a successful refresh?
The update may be hidden by a filter or grouping, or a changed record may not affect the displayed total noticeably. Clear filters, expand grouped fields, inspect the source row, and confirm that the PivotTable summarizes the field you intended to change.
Related
- Copy and Paste X Times in Excel: Repeat Cells or Rows
- Convert H:M:S to a Number in Excel
- Contact Number List Template for Excel: Setup Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Skip Blank Data? Control Gaps and ZerosYes. In Excel for Microsoft 365, a chart can show blank cells as gaps, treat them as zero,…
- Create a Horizontal Line in an Excel Chart: MethodsTo create a horizontal line in an Excel chart, add another data series whose value is the same…
- How to Make a Chart in Excel: A Clear Step-by-Step GuideTo make a chart in Excel, arrange your information in labeled rows or columns, select the data, then…
- Excel Box Plot X-Axis Labels: Set and Fix ThemIn Excel for Microsoft 365 on Windows, a box plot’s x-axis labels normally come from the column headers…
- Creating an Org Chart in PowerPoint: Steps and TipsTo create an org chart in PowerPoint for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy,…
- Excel Pivot Chart: Show Only Certain ColumnsYes. In Excel for Microsoft 365 on Windows, select the PivotChart and use the drop-down on the relevant…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.