No—an Excel PivotTable in Microsoft 365 for Windows does not normally update as soon as you change its source cells. Select the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to update the workbook’s connected data and reports.
What “update automatically” means
A PivotTable summarizes data from a source, such as a worksheet range, an Excel table, an external connection, or the workbook Data Model. It keeps a snapshot of that source in a pivot cache or obtains data through a connection. When you edit the source, the PivotTable usually continues to show its previous summary until you refresh it.
Refresh is the step that tells Excel to read the source again and recalculate the summary. For example, if a sales record changes from $120 to $150, the underlying cell may show $150 immediately, while the PivotTable total remains based on $120 until a refresh. The same applies when you add or delete records, change a category, or update a source formula.
There is an important distinction: some parts of the source setup can adjust automatically, but that does not necessarily refresh the report. An Excel table can grow as you add records, for instance, while a PivotTable based on that table still needs refreshing to include the new values.
How PivotTable refresh works
A PivotTable is not simply a live view of each source cell. Excel stores or accesses summarized-source information so that it can organize fields, calculate totals, and respond quickly when you rearrange the report. Refresh asks Excel to check the source again and update the PivotTable’s results.
That means changes in the source and changes in the PivotTable layout are different things. Dragging a field from Rows to Columns changes the display, not the source data. Editing a source value changes the underlying record, but the existing summary can remain unchanged until refresh. A refresh can update the values without changing the fields or layout you have arranged.
Refresh timing also depends on what the source is. A PivotTable built from a local worksheet table can usually refresh directly. A PivotTable that uses a database, Power Query output, or another external connection may need that connection to refresh successfully first. If Excel cannot access the source, the PivotTable may keep showing older results or report an error.
When the source is an Excel table or a cell range
Using an Excel table is often the simplest way to make a PivotTable’s source handle new records reliably. Select a cell in the source data, choose Insert > Table, confirm that the range and headers are correct, and create the PivotTable from that table. When you type or paste a new row directly below the table, Excel normally expands the table to include it.
However, table expansion and PivotTable refresh are separate. After adding the row, refresh the PivotTable so the new record appears in its totals and filters. For example, a table named SalesData might gain a new order for the West region. The table can include that order automatically, but the West total in an already-open PivotTable may not change until you refresh.
A PivotTable sourced from a plain range has another potential issue: new records may fall outside the original address. If the source was A1:D100 and a new record is placed in row 101, refreshing does not always mean Excel will extend that fixed range. Select the PivotTable and use PivotTable Analyze > Change Data Source to inspect or revise the source. Converting the source to a table can reduce this maintenance.
- For existing rows: edit the source, then refresh the PivotTable.
- For new rows in a table: check that the table expanded, then refresh.
- For new rows outside a fixed range: extend or change the source before refreshing.
Ways to refresh a PivotTable
For a single report, click inside the PivotTable and choose PivotTable Analyze > Refresh. You can also right-click a PivotTable cell and choose Refresh. The command updates that PivotTable from its source while preserving its report layout.
To refresh multiple reports and connections, choose Data > Refresh All. This is useful when a workbook has several PivotTables, query results, or external data connections that need updating together. Because the operation may take time, wait for it to finish before deciding that the report is still stale. Connected sources may prompt for credentials or depend on a network connection.
On Windows, Alt+F5 refreshes the selected PivotTable, while Ctrl+Alt+F5 refreshes all data connections and PivotTables in the workbook. If a shortcut is intercepted by a device or another application, use the ribbon command instead. Excel for Mac has different keyboard conventions, and the available commands are best found on its PivotTable and Data tabs; the right-click Refresh option is also available in many builds.
When you refresh a PivotTable, Excel may preserve certain formatting and layout choices, but report behavior can depend on its settings and source. If a refresh changes column widths unexpectedly, select a PivotTable cell, open PivotTable Analyze > Options, and check the layout and formatting options. Avoid repeatedly rebuilding the PivotTable just to update values: refresh is generally the appropriate first action.
Refresh when the workbook opens
You can configure a PivotTable to refresh when its workbook opens. Click inside the PivotTable, choose PivotTable Analyze > Options, and in the PivotTable Options dialog open the Data tab. Select Refresh data when opening the file, then confirm. The option applies to the selected PivotTable; check other PivotTables separately if you need them to refresh on opening too.
This setting is useful for reports that are opened after their source data has changed. It does not mean the PivotTable refreshes continuously while the file remains open. It also cannot guarantee fresh results if an external source is unavailable, access is denied, or the workbook opens with a connection that requires user action. A report that must be current should still be checked after opening, especially when it depends on external data.
Excel for Mac presents PivotTable options through its own ribbon and dialog layout, which can differ slightly by release. The equivalent setting is in the PivotTable options for the selected report. In Excel for the web, available PivotTable and connection controls can vary; use the refresh command offered in that workbook rather than assuming desktop settings work identically.
Can a PivotTable refresh after every edit?
In the standard Excel desktop workflow, there is no general PivotTable setting that refreshes the report immediately after every change to ordinary worksheet cells. The refresh-on-open option is not the same as live updating, and choosing Refresh All is a manual action. A PivotTable connected to a changing external source also does not necessarily update the screen the instant that source changes.
For a hands-off process, a workbook can use a macro or an automated data workflow, but each approach has trade-offs. A VBA event macro can be written to refresh a report in response to certain worksheet changes, but it must be designed carefully: refreshing after every keystroke can slow a workbook, cause repeated calculations, and behave badly when data is pasted in bulk. Macros may also be blocked by security settings or unavailable in some Excel environments.
Power Query can automate the steps that import and transform data, but loading a query is not the same as making a PivotTable continuously live. The query and PivotTable may each need refreshing, often together through Data > Refresh All. For many users, a good practical routine is to keep the source in an Excel table and refresh the report when data entry is complete.
Common reasons a refresh does not show the expected result
If you clicked Refresh and a new record is missing, check the source before changing the PivotTable layout. Confirm that the record is inside the table or source range, that the field names are present and consistent, and that the relevant cell contains the value you expect. A value stored as text may sort or summarize differently from a number, and blank or inconsistent category labels can create unexpected items.
- The source range stops too early: use PivotTable Analyze > Change Data Source to inspect the address, or use a table that expands with new records.
- The record is filtered out: inspect report filters, slicers, and field selections; refresh does not remove a filter you intentionally applied.
- The displayed total seems old: refresh the correct PivotTable, not a different report on the same sheet. Use Refresh All if several reports share related data.
- An external refresh fails: check the network, credentials, permissions, and connection status. A PivotTable cannot retrieve data it cannot access.
- Old field items remain visible: PivotTable options include controls for retaining items deleted from the source. Review the Data settings if obsolete labels persist after refresh.
Also consider whether the source itself has recalculated. If a source column contains formulas, Excel’s calculation settings affect when those formulas produce new results; refreshing a PivotTable does not repair an incorrect or not-yet-calculated source formula. Check the source cells first, then refresh the report.
Frequently Asked Questions
Does an Excel PivotTable update when I change a cell?
No, not usually in desktop Excel. The source cell changes, but the PivotTable summary generally remains as it was until you choose Refresh or Refresh All.
Will a PivotTable include rows I add to the source?
It will if the rows are included in its source when it refreshes. An Excel table normally expands when you add records beneath it, but you still need to refresh the PivotTable. A fixed range may need to be extended first.
How do I refresh all PivotTables in a workbook?
Choose Data > Refresh All. On Windows, Ctrl+Alt+F5 is the corresponding shortcut in Microsoft 365. Wait for external queries to finish before checking the results.
Can I make a PivotTable refresh automatically when I open the file?
Yes. Select the PivotTable, open PivotTable Analyze > Options, go to the Data tab, and select Refresh data when opening the file. Set it for each PivotTable that needs this behavior.
Why does Refresh not include my new row?
The new row may be outside the PivotTable’s source range, or a filter may be hiding it. Check the source address with PivotTable Analyze > Change Data Source, confirm the row is included, and refresh again.
Related
- Data Validation Interview Questions and Strong Answers
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Linear Trendline in Excel: Make One and Show Its EquationTo make a linear trendline in Excel for Microsoft 365 on Windows, select your paired data, choose Insert…
- Excel Charts With Dynamic Ranges: Setup and OptionsTo make an Excel chart grow when you add data, convert the source range into an Excel Table,…
- Unique Excel Chart Designs: Ideas and How to Build ThemUnique Excel chart designs combine a chart type suited to the data with thoughtful formatting, labels, and context.…
- Excel Trendline Error: Causes and FixesIf an Excel trendline will not appear, select a supported chart series and choose Chart Design > Add…
- Google Sheets Chore Chart Template: Build a Shared ScheduleA Google Sheets chore chart template is a shared spreadsheet for listing household tasks, assigning them, and marking…
- 3D Pie Chart in Excel: Create, Format, and Improve ItTo make a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column range containing…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.