Pivot Table Issues

Fix an Excel PivotTable That Does Not Include New Rows

Steve KSteve K Nov 18, 2026 869 views

Question details

The user needs an Excel PivotTable to include newly added source rows.

Fix an Excel PivotTable That Does Not Include New Rows
Product
Microsoft Excel
Device & OS
not provided
Scenario
New records have been added below the data used to create a PivotTable.
Observed behavior
The PivotTable omits new records when they fall outside its source range.
Before you start

Check that the new records have values under the existing column headers and identify the last row of the source data. If the source already covers entire columns, such as A:I, try refreshing the PivotTable first.

Solution 1Recommended

Convert the source data to an Excel Table

Use a table as the source when you regularly add rows and want the source range to expand automatically.

1
Create a table

Select the source data, including headers and new rows, then choose Insert > Table. Confirm the range and select My table has headers if applicable.

2
Find the table name

Click inside the table and check the Table Name box on the Table Design tab.

3
Update the PivotTable source

Click the PivotTable, choose PivotTable Analyze > Change Data Source, and enter or select the table name in the Table/Range field. Click OK.

4
Refresh the PivotTable

Right-click the PivotTable and select Refresh. Check that the new records appear in the results.

Convert the source data to an Excel Table
Refresh after adding data: Rows added directly below an Excel Table normally expand the table automatically, but the PivotTable still needs to be refreshed to show them.
Work with spreadsheets in WPS Office

Update a PivotTable source in WPS Spreadsheets

Open your workbook in WPS Spreadsheets, expand the PivotTable source to include the new rows, and refresh the PivotTable.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
  2. 2. Select the PivotTable: Click inside the PivotTable to display its contextual tools.
  3. 3. Change the source range: Choose Change Data Source from the PivotTable tools, then select a range that includes the headers and new rows. Confirm the selection.
  4. 4. Refresh the results: Right-click the PivotTable and choose Refresh, then check that the new records are included.
Expand a PivotTable source to include new recordsOpen and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet data in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why are new rows missing after I refresh my PivotTable?

They may be outside the source range. Click the PivotTable and choose PivotTable Analyze > Change Data Source to check and expand the range.

Does an Excel Table refresh a PivotTable automatically?

No. An Excel Table normally expands when rows are added directly below it, but you still need to right-click the PivotTable and select Refresh.

Will a source range such as A:I include new rows?

A:I refers to entire columns, so rows added within those columns are already in the range. Refresh the PivotTable and check its filters if the records do not appear.

What if the new rows are included but still do not appear?

Right-click the PivotTable and select Refresh, then check the field filters for excluded items. Also confirm that the new records are under the correct source headers.