Pivot Table Issues

How to Automatically Include New Rows in an Excel PivotTable

Partner Editor Sep 29, 2026 868 views

Question details

The user wants to configure a PivotTable so that newly added data rows are automatically included without having to manually update the source data range.

How to Automatically Include New Rows in an Excel PivotTable

Product: Excel
Device & OS: not provided
Scenario: Adding new data entries or form responses to an existing dataset connected to a PivotTable.
Observed behavior: Currently, the user must repeatedly select the data range to include new rows. The goal is to automate this process so new rows are included seamlessly upon refreshing.

Before you start

Ensure your dataset does not have any entirely blank rows or columns before converting it to an Excel Table, as this can disrupt the PivotTable structure.

Solution 1Recommended

Format Data Range as an Excel Table

Using an Excel Table as your PivotTable source automatically expands the data range when new rows are added.

By default, PivotTables are locked to the specific range of cells you select during creation. Converting your data source into an official Excel Table makes the range dynamic, meaning any new entries added to the bottom will automatically become part of the dataset without requiring you to manually redefine the source range.

Select the Data Range

Highlight any cell within your current dataset.

Convert to an Excel Table

Press the Ctrl + T keyboard shortcut. In the popup dialog, confirm the data range, ensure the 'My table has headers' checkbox is ticked, and click OK.

Set the PivotTable Source

Insert a new PivotTable using this Table as the source (e.g., 'Table1'), or change your existing PivotTable's data source to match the new table name.

Refresh the PivotTable

When new rows are added through data-entry forms or manual input, right-click anywhere inside the PivotTable and select 'Refresh' to display the updated data.

Auto-Refresh Option: To avoid refreshing manually every time you open the workbook, you can enable automatic updates by going to PivotTable Options > Data and checking the 'Refresh data when opening the file' box.

Manage Data Seamlessly

Easily Manage Dynamic PivotTables in WPS Spreadsheet

WPS Spreadsheet fully supports Excel Tables and dynamic PivotTables, allowing you to effortlessly summarize growing datasets without repeatedly adjusting data ranges manually.

1. Format as Table: Open your spreadsheet in WPS Office, select your data range, and press Ctrl+T to quickly create a table.
2. Insert PivotTable: Go to the 'Insert' tab, click 'PivotTable', and verify your new Table name is set as the data source.
3. Refresh Data: Right-click the PivotTable and select 'Refresh' whenever new form entries or rows are added to your table to see instant updates.

Fully compatible with Microsoft Excel (.xlsx) formats and PivotTable configurations.Free, lightweight, and fast data analysis tool with an intuitive interface.Easily format data as tables to create dynamic ranges for charts and reports.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my PivotTable not updating immediately after adding data to the Excel Table?

A PivotTable does not refresh in real-time as you type. You must manually right-click the PivotTable and choose 'Refresh', or click 'Refresh All' in the Data tab to command the PivotTable to fetch the newly added data.

Can I automatically include new columns in the PivotTable as well?

Yes, if your data source is formatted as an Excel Table, typing a new header in a column directly adjacent to the table will automatically incorporate it into the table range. After refreshing the PivotTable, the new column will appear in your PivotTable Fields list.

How do I find the exact name of my Excel Table to use as the source?

Click anywhere inside your formatted Table, go to the 'Table Design' (or 'Table Tools') tab on the top ribbon, and look at the 'Table Name' box on the far left. You can copy the exact name or rename the table from there.

Excel & Data Problems