Pivot Table Issues

Refresh an Excel PivotTable After Renaming Source Columns

Khadija KhanKhadija Khan Nov 18, 2026 868 views

Question details

Update the PivotTable field list to reflect a renamed source column.

Refresh an Excel PivotTable After Renaming Source Columns
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.
Before you start

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.

Solution 1Recommended

Refresh the PivotTable and verify its source

Use this when source columns have changed but the PivotTable still shows the previous field names.

1
Refresh the PivotTable

Right-click any cell inside the PivotTable and select Refresh. Alternatively, select the PivotTable and choose PivotTable Analyze > Refresh.

2
Check the field list

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.

3
Verify the data source

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.

4
Refresh again

Right-click the PivotTable and select Refresh again, then check the PivotTable Fields pane for the combined column.

Refresh the PivotTable and verify its source
Check the layout: Renaming or removing source columns can affect fields already used in the PivotTable. Add the new field to the appropriate layout area if it is not placed there automatically.
Work with PivotTables in WPS

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. 1. Open the workbook: In WPS Spreadsheets, choose Open and select the Excel workbook containing the PivotTable.
  2. 2. Check the source header: Open the source worksheet and confirm that the combined column header is First Arg/Description.
  3. 3. Refresh the PivotTable: Select the PivotTable, right-click it, and choose Refresh.
  4. 4. Update the layout: Check the PivotTable field list and drag First Arg/Description into the desired layout area if needed.
Refresh PivotTables after source column names changeOpen and edit Microsoft Excel XLSX and XLS filesArrange fields in a familiar spreadsheet interfaceUse a free office suite for spreadsheet work
microsoft office alternative - wps office

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.