Refresh an Excel PivotTable After Renaming Source Columns
Question details
Update the PivotTable field list to reflect a renamed source column.

- Product
- Microsoft Excel PivotTable
- Device & OS
- not provided
- Scenario
- The source columns First Arg and Description were combined into a single column named First Arg/Description.
- Observed behavior
- The PivotTable field list still displays the old column names.
Check that the source data has one header row and that the combined column is named First Arg/Description. Each source column should have a nonblank, unique header; avoid merged cells in the header row.
Refresh the PivotTable and verify its source
Use this when source columns have changed but the PivotTable still shows the previous field names.
Right-click any cell inside the PivotTable and select Refresh. Alternatively, select the PivotTable and choose PivotTable Analyze > Refresh.
Open the PivotTable Fields pane and look for First Arg/Description. If needed, drag the new field into the Rows, Columns, Values, or Filters area to replace an old field.
If the old names remain, select the PivotTable and choose PivotTable Analyze > Change Data Source. Confirm that the selected range or table includes the updated header and data, then click OK.
Right-click the PivotTable and select Refresh again, then check the PivotTable Fields pane for the combined column.

Create a new PivotTable from the updated source
Use a new PivotTable if the existing field list still does not reflect the corrected source after refreshing.
Refresh a PivotTable in WPS Spreadsheets
Open your workbook in WPS Spreadsheets, check the updated source headers, and refresh the PivotTable to use the renamed field.
- 1. Open the workbook: In WPS Spreadsheets, choose Open and select the Excel workbook containing the PivotTable.
- 2. Check the source header: Open the source worksheet and confirm that the combined column header is First Arg/Description.
- 3. Refresh the PivotTable: Select the PivotTable, right-click it, and choose Refresh.
- 4. Update the layout: Check the PivotTable field list and drag First Arg/Description into the desired layout area if needed.

Frequently Asked Questions
Why does my PivotTable still show old column names?
The PivotTable may not have been refreshed, or its source may still point to an outdated range or table. Right-click the PivotTable and select Refresh, then check PivotTable Analyze > Change Data Source if the names remain.
Will refreshing automatically replace the old fields in my layout?
Not necessarily. After refreshing, check the PivotTable Fields pane and drag First Arg/Description into the appropriate Rows, Columns, Values, or Filters area if needed.
Why does Excel say the PivotTable field name is not valid?
The source range may contain a blank or merged header cell. Check that every source column has a nonblank, unique header, then select the corrected range under PivotTable Analyze > Change Data Source and refresh.
What should I do if the renamed field still does not appear?
Confirm that the PivotTable source includes the updated column. If it does and refreshing still does not help, select the updated data and choose Insert > PivotTable to create a new PivotTable.




