Pivot Table Issues

How to Fix PivotTable Not Showing New Categories After Refresh in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user added a new transaction or category to an Excel Table used as a PivotTable source, but the new data does not appear in the PivotTable even after hitting refresh.

Product: Excel
Device & OS: not provided
Scenario: Updating an existing PivotTable with newly added data entries from a source table.
Observed behavior: The new category or transaction remains hidden in the PivotTable after attempting to refresh the data.

Before you start

Verify that your newly added data contains no completely blank rows separating it from the main dataset, as this can break the data source continuity.

Solution 1Recommended

Verify Data Source Range and Refresh

Check if the newly added row is actually included in the PivotTable's defined data source range, update it if necessary, and refresh.

Often, new data falls outside the originally defined range of the PivotTable. Adjusting the source range to encompass the entire table ensures all new entries are captured.

Access PivotTable Tools

Select any cell inside your PivotTable to reveal the PivotTable Analyze tab on the Excel ribbon.

Change Data Source

Navigate to PivotTable Analyze > Change Data Source.

Verify the Range

Check the highlighted area and ensure the data range includes your complete Excel Table along with the newly added rows. Adjust the selection if it stops above your new data, then click OK.

Refresh Data

Click the Refresh button or select Refresh All to update the PivotTable with the included data.

Solution 2

Clear Excluded Item Filters

Remove manual item filters that might be hiding the newly added category from view.

Effortless Data Management

Easily Manage and Refresh PivotTables with WPS Spreadsheet

WPS Office provides a highly compatible and intuitive Spreadsheet tool where updating PivotTables is fast and seamless. Prevent complex data range issues by utilizing dynamic tables in a lightweight, user-friendly environment.

1. Open Your File: Launch WPS Spreadsheet and open your existing Excel workbook.
2. Update the Source Data: Add your new data rows to the source table just as you normally would.
3. Refresh PivotTable: Navigate to the Data tab on the ribbon and click Refresh All to instantly update your PivotTable with the new categories.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats and PivotTable structures.One-click Refresh All for fast and accurate data updates.Lightweight application that uses minimal system resources.Familiar interface requires zero learning curve for Excel users.

Frequently Asked Questions

Why do I have to keep manually updating the data source range for my PivotTable?

If you use a static cell range (like A1:D50) instead of a formatted Excel Table, new rows added below row 50 will not be included automatically. Select your source data and press Ctrl+T to format it as a Table, which ensures your PivotTable updates dynamically when new data is added.

Does clicking 'Refresh All' update multiple PivotTables at once?

Yes, clicking 'Refresh All' updates all PivotTables, PivotCharts, and external data connections throughout the entire workbook simultaneously.

Why is my new data showing up as a '(blank)' category in the PivotTable?

This typically happens if you select entire columns (e.g., A:D) as your data source, which includes millions of empty rows below your actual data. It is strongly recommended to use a named Table instead of entire columns to prevent the '(blank)' category from appearing.

Can hidden rows in the source data affect what is shown in the PivotTable?

Normally, hidden rows in the source data are still included in standard PivotTable calculations. However, if your data model utilizes advanced filtering or subtotal functions designed to ignore hidden rows, those categories might not be displayed.

Excel & Data Problems