Fix an Excel PivotTable That Does Not Include New Rows
Question details
The user needs an Excel PivotTable to include newly added source 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.
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.
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.
Select the source data, including headers and new rows, then choose Insert > Table. Confirm the range and select My table has headers if applicable.
Click inside the table and check the Table Name box on the Table Design tab.
Click the PivotTable, choose PivotTable Analyze > Change Data Source, and enter or select the table name in the Table/Range field. Click OK.
Right-click the PivotTable and select Refresh. Check that the new records appear in the results.

Expand the PivotTable source range manually
Use this method for a one-time update or when you do not want to convert the source data to a table.
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. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
- 2. Select the PivotTable: Click inside the PivotTable to display its contextual tools.
- 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. Refresh the results: Right-click the PivotTable and choose Refresh, then check that the new records are included.

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.




