Pivot Table Issues

How to Fix New Data Missing from Excel PivotTable

Natalie TaylorNatalie Taylor Nov 10, 2026 869 views

Question details

The user added new data to their spreadsheet, but it does not appear in the existing PivotTable.

How to Fix New Data Missing from Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Format data as Table

Select any cell within your source data. Press Ctrl+T (or go to Insert > Table), confirm the data range is correct, and click OK.

2
Refresh the PivotTable

Navigate to the sheet containing your PivotTable. Right-click anywhere inside the PivotTable and select 'Refresh'.

3
Verify the update

Check your PivotTable fields and values to confirm that the newly added data is now visible and calculated.

Convert Source Data to a Table and Refresh
Dynamic Updates: Once converted to a Table, any future data added directly adjacent to the table will be automatically included in the source range upon the next refresh.
Manage Data Effortlessly

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. 1. Open your workbook: Launch WPS Spreadsheet and open the file containing your data and PivotTable.
  2. 2. Format source as Table: Highlight your source data and click 'Format as Table' under the Home tab to make it dynamic.
  3. 3. Refresh instantly: Whenever you add new data, simply right-click the PivotTable and choose 'Refresh' to immediately reflect the changes.
Fully compatible with Microsoft Excel (.xlsx) formats and PivotTable structures.One-click refresh for dynamically updating PivotTable data.Built-in 'Format as Table' feature to auto-expand source data ranges.Lightweight software with a familiar, easy-to-use interface.
microsoft office alternative - wps office

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.