How to Fix New Data Missing from Excel PivotTable
Question details
The user added new data to their spreadsheet, but it does not appear in the existing PivotTable.

- Product
- Excel / WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Updating a PivotTable after adding new rows or columns to the source data.
- Observed behavior
- New data is missing from the PivotTable even after the source data has been updated.
Ensure you have saved your workbook and note the exact rows or columns you recently added to the source data so you can verify their inclusion.
Convert Source Data to a Table and Refresh
Converting your data range to an official Excel Table ensures that any new rows or columns are automatically included in the PivotTable's data source.
By default, PivotTables use a fixed static range. If you add data below or to the right of this range, the PivotTable ignores it. Formatting the source data as a Table makes the range dynamic.
Select any cell within your source data. Press Ctrl+T (or go to Insert > Table), confirm the data range is correct, and click OK.
Navigate to the sheet containing your PivotTable. Right-click anywhere inside the PivotTable and select 'Refresh'.
Check your PivotTable fields and values to confirm that the newly added data is now visible and calculated.

Update the PivotTable Data Source Range Manually
If you prefer not to use an Excel Table, you must manually expand the PivotTable's source range to include the new data.
Check for Hidden Filters and Text-Formatted Numbers
Sometimes data is included in the source range but remains hidden due to active filters, incorrect formatting, or duplicate field names.
Easily Manage and Update PivotTables in WPS Office
WPS Spreadsheet provides intuitive tools for creating, updating, and managing PivotTables. You can easily refresh data, format ranges as tables, and perform complex data analysis efficiently.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing your data and PivotTable.
- 2. Format source as Table: Highlight your source data and click 'Format as Table' under the Home tab to make it dynamic.
- 3. Refresh instantly: Whenever you add new data, simply right-click the PivotTable and choose 'Refresh' to immediately reflect the changes.

Frequently Asked Questions
Why are my numbers not summing up correctly in the PivotTable?
If numbers are stored as text in the source data, the PivotTable will count them instead of summing them. Go back to your source data, select the cells with the error warning, choose 'Convert to Number', and then refresh the PivotTable.
Does the PivotTable update automatically when I open the file?
Not by default. You can enable this feature by right-clicking the PivotTable, selecting 'PivotTable Options', navigating to the 'Data' tab, and checking the box for 'Refresh data when opening the file'.
What happens if my source data has blank headers?
PivotTables require a valid name for every column in the source range. If a header is blank, Excel or WPS Spreadsheet will return an error when you try to create or refresh the PivotTable. Always ensure every column has a unique header.




