How to Add a New Excel Table Column to an Existing PivotTable in WPS Office
Question details
The user added a new column to the source data in WPS Office Excel, but the column does not appear as a field in an existing PivotTable and needs to be added to the PivotTable field list.
- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- An existing PivotTable is based on a data range or Excel Table, and the user adds a new source column that should become available in the PivotTable Fields list.
- Observed behavior
- The new source column is not automatically listed as a PivotTable field because the PivotTable uses a fixed cell range or has not been refreshed.
Make sure the workbook is open in WPS Office Excel and identify whether the PivotTable source is an Excel Table or a normal range. If it is a normal range, note the current source range so you can extend it to include the new column.
Refresh the PivotTable when the source is an Excel Table
Use this method when the PivotTable source data is formatted as an Excel Table. The new column normally appears after you refresh the PivotTable.
Open the worksheet in WPS Office Excel and type the new column header in the first empty column immediately next to the existing Excel Table. The table expands automatically to include it.
Click any cell inside the PivotTable that should show the new field.
Go to the PivotTable Analyze tab and click Refresh, or right-click the PivotTable and choose Refresh.
Open the PivotTable Fields panel and confirm the new column appears in the field list.
Expand the PivotTable source range for a normal data range
Use this method when the PivotTable source is a fixed range and the new column sits outside the current source range.
Add the Missing Column to Your WPS Office PivotTable
In WPS Office Excel, you can make a newly added source column available by refreshing an Excel Table-based PivotTable or by changing the data source to include the new column. The PivotTable tools use the familiar ribbon layout, so the fix is quick and keeps your report structure intact.
- 1. Open the workbook in WPS Office Excel: Launch WPS Office and open the Excel workbook that contains the source data and PivotTable.
- 2. Add or locate the new column: Type the new column header next to the source data, ensuring it is within the same Excel Table or adjacent to the current range.
- 3. Refresh or change the data source: Click the PivotTable, go to PivotTable Analyze, and use Refresh for an Excel Table or Change Data Source for a normal range.
- 4. Add the field to the PivotTable: Open the PivotTable Fields panel and drag the new column into the desired report area.
Frequently Asked Questions
Why is my new Excel column not showing in the PivotTable field list?
Usually the PivotTable is based on a fixed cell range or has not been refreshed. Click the PivotTable, open PivotTable Analyze, then use Refresh or Change Data Source to include the new column.
Does WPS Office automatically expand an Excel Table when I add a new column?
Yes, when you type in the column immediately next to an existing Excel Table, WPS Office Excel includes it in the table. You still need to refresh the PivotTable to see the new field.
How do I change the PivotTable data source from a normal range in WPS Office?
Click any cell in the PivotTable, go to PivotTable Analyze > Change Data Source, then select the expanded range that includes the new column and click OK.
Can I add the new column directly from the PivotTable Fields panel?
No. The column must first exist in the source data and be included in the PivotTable source range or table. After a refresh, you can drag it from the field list into the PivotTable.
What should I check if the new column still does not appear after changing the source range?
Confirm the expanded range includes all rows and the new header, click Refresh again, and make sure you did not place the new column in a separate blank area outside the source.
