Excel Pivot Table Not Updating? Fix the Source Data

If an Excel PivotTable is not showing new rows, refresh it and check whether its source includes those rows. Use PivotTable Analyze > Change Data Source to correct a fixed or incomplete range, then choose PivotTable Analyze > Refresh. For data that grows regularly, convert the source to an Excel Table so new adjacent rows can be included more reliably.

What refreshing a PivotTable actually does

A PivotTable summarizes data from a source range, Excel Table, connection, or Data Model. It does not necessarily recalculate its summary every time you edit a source cell. Refreshing tells Excel to read the available source again and update the PivotTable’s stored summary, often called its cache.

There are two separate things to check: whether Excel has refreshed, and whether the source it refreshed covers the new records. Refreshing cannot bring in a row that sits outside the source range. Conversely, changing the source range does not always update the displayed results until you refresh.

For example, a PivotTable based on A1:D100 will not include a newly entered record in row 101 just because you click Refresh. The source still ends at row 100. If the source is an Excel Table that has expanded to include the new record, Refresh can update the summary from that larger source.

Quick checks to find the cause

Start with the simplest checks before rebuilding the PivotTable. Confirm that the new record is in the correct source sheet and that it has values under the same column headers as the existing data. Then check the source itself and the PivotTable’s filters.

Click inside the PivotTable and choose PivotTable Analyze > Change Data Source. Check whether the displayed range reaches the new rows, or whether the source is an Excel Table.
Choose PivotTable Analyze > Refresh. If the workbook contains several PivotTables or connections, try Data > Refresh All.
Look for report filters, row or column label filters, slicers, and timelines that may be hiding the new category or date.
Check that the source has one header row, a header for every column, and no blank row separating the old records from the new ones.

If the source range is correct and refresh completes but the record remains absent, inspect the source values and filters more closely. A text value that looks like a date, for example, may not behave like the real dates in the same column.

Use an Excel Table for data that keeps growing

An Excel Table is usually the simplest durable source for a PivotTable that will receive additional records. Tables have names and expand to include data entered or pasted directly beneath them. When the PivotTable uses the Table as its source, refreshing can then pick up the added rows without manually editing a fixed address each time.

Click a cell in the source data and choose Insert > Table. Confirm the selected range and select My table has headers if the first row contains column names.
Give the Table a meaningful name on the Table Design tab, such as SalesData. Avoid spaces in the name.
Create a PivotTable from a cell in the Table using Insert > PivotTable, or change an existing PivotTable’s source to the Table name through PivotTable Analyze > Change Data Source.
Add new records immediately below the Table, then refresh the PivotTable.

Tables can expand automatically when data is entered or pasted directly next to them, but a blank row or column can prevent Excel from recognizing the new records as part of the Table. If necessary, select the Table and use Table Design > Resize Table to include the added cells. Creating a new PivotTable from the Table is not required every time data changes; refresh the existing PivotTable.

Change a fixed source range

If the PivotTable was created from a regular cell range, its source may remain fixed at the original address. Click inside it, select PivotTable Analyze > Change Data Source, and update the range in the Table/Range box. Include the header row and every data row, then confirm and refresh. For instance, change a source such as January!$A$1:$D$100 to January!$A$1:$D$125 if the added records occupy rows 101 through 125.

Take care not to include unrelated notes or totals beneath the dataset. A total row can be interpreted as an ordinary record and distort the summary. If new rows are added often, converting the source into a Table is less error-prone than repeatedly extending the range. A fixed range can still be appropriate when the source is intentionally a fixed-size extract.

Refresh one PivotTable or the whole workbook

To refresh one report in Excel for Microsoft 365 on Windows, click inside it and choose PivotTable Analyze > Refresh. You can also right-click a PivotTable cell and choose Refresh. To update multiple PivotTables and workbook connections, choose Data > Refresh All. Refresh All may take longer, especially if the workbook retrieves information from external sources.

Excel also has a setting to refresh a PivotTable when the workbook opens. Right-click inside the PivotTable, choose PivotTable Options, open the Data tab, and select Refresh data when opening the file, if that option is available for its source. This helps keep the report current when opened, but it does not fix an incomplete source range or a failed connection.

Excel for Mac has PivotTable refresh commands as well; ribbon labels and locations can vary somewhat by release. Excel for the web supports many PivotTable tasks, but available refresh options can depend on the workbook and its data source. If a connection, Data Model, or desktop-only feature is involved, open the workbook in the desktop version and check the connection’s refresh status there.

Check filters, labels, and source data

A refresh can succeed while a filter continues to hide the new item. Open the dropdown beside the relevant PivotTable field and inspect the selected items. Clear the filter temporarily to see whether the category appears. Also check slicers and timelines: a slicer selection can exclude a new category or a date outside the selected period even when the source and cache are current.

Look at the underlying data for inconsistencies. PivotTables treat values such as North and North (with a trailing space) as different labels. Similarly, numbers stored as text may not summarize like numeric values. Dates must be recognized as dates for date grouping and timeline behavior. A quick way to investigate is to locate the row in the source and compare its cell format and actual value with nearby records.

Keep the source as a simple list: one header row, one record per row, and one type of information per column. Avoid merged cells, completely blank header cells, and subtotal rows inside the data. These layout problems can cause errors when creating or changing a PivotTable source, or lead to unexpected summaries.

Connections, Data Models, and other special cases

Some PivotTables are based on a query, an external database, or the workbook Data Model rather than a plain worksheet range. In those cases, refreshing the PivotTable may depend on refreshing the underlying query or connection first. Choose Data > Refresh All and watch for a sign-in prompt, connection error, privacy prompt, or message that the data could not be retrieved. A PivotTable cannot show records that the upstream source did not return.

If the PivotTable uses the Data Model, its source and refresh process can differ from a normal range-based PivotTable. Check the queries or connections that load data into the model and confirm their refresh completed. If the PivotTable is based on a database or shared file, also verify that the source file is accessible and that the connection points to the intended location. A cached report may continue to display older results if a connection fails.

When refresh appears to do nothing, compare a specific new source record with the report’s field layout. The record might be present but grouped under an unexpected label, excluded by a value filter, or not displayed because its field is not used in the PivotTable. Refresh updates what the source provides; it does not automatically redesign the report.

Prevent the problem on future updates

A small routine makes recurring reports more dependable. Store raw records in one Table, keep its column headers stable, and append new records directly to the Table rather than creating a separate block elsewhere on the sheet. Then refresh the PivotTable and review the report filters before sharing it.

Use clear, unique column headers and do not leave a blank row inside the dataset.
Keep dates as dates and amounts as numbers, not text that merely looks numeric.
Base the PivotTable on the expanding Table instead of a range that ends at a fixed row.
For external data, confirm that the connection can refresh and that the workbook is saved after successful updates.

Remember that refreshing and changing the source solve different problems. Refresh when the source already includes the rows; change or expand the source when it does not. Once that distinction is clear, most “PivotTable not updating” cases can be diagnosed without recreating the report.

Frequently Asked Questions

Why does Refresh not include the new rows?
Most often, the PivotTable uses a fixed source range that stops before those rows. Check Change Data Source, extend the range or use an Excel Table, and refresh again.

Do I have to recreate a PivotTable after adding data?
No. If the source includes the added data, refresh the existing PivotTable. Recreate it only if you need a different report structure or cannot adapt the existing source.

How do I make a PivotTable update automatically?
Use an Excel Table as the source so it can expand as records are added, then refresh the PivotTable. You can also enable Refresh data when opening the file in PivotTable Options when supported. That setting is not the same as refreshing after every edit.

Why is a new category missing after Refresh All?
Check field filters, slicers, timelines, and value filters first. If those are clear, look for inconsistent spelling, extra spaces, or a source row outside the Table or source range.

Does Refresh All update every PivotTable?
It refreshes workbook data connections and refreshable reports, but the result still depends on each PivotTable’s source and connection being valid. Check for errors or prompts if a report remains stale.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.