Rename a Field in an Excel PivotTable or PivotChart
Question details
The user needs to rename a field shown in an Excel PivotTable or PivotChart and determine why the field name may be unavailable for editing.
- Product
- Microsoft Excel PivotTable and PivotChart
- Device & OS
- not provided
- Scenario
- A user wants to replace a PivotTable or PivotChart field heading with a more meaningful name.
- Observed behavior
- Fields connected to an OLAP cube, Data Model, or external data source may be controlled by the source and cannot be renamed directly in the PivotTable.
Click inside the PivotTable and identify whether it is based on a local Excel range or table, or on an external connection. For connected data, make sure you have permission to edit the source query, model, or source-system metadata.
Rename a field in a standard Excel PivotTable
Use this method when the PivotTable is created from a regular Excel range or Excel table and the field caption is editable.
Click the PivotTable field heading or custom caption that you want to change, such as a Row Labels, Column Labels, or Values field name.
Type the new field name directly in the selected PivotTable heading or in the PivotTable Fields pane, then press Enter.
If Excel rejects the new name because it already exists, add a distinguishing word or character, then press Enter again.
Click the linked PivotChart and confirm that its legend, axis, or filter field reflects the revised PivotTable caption.
Change field names for OLAP, Data Model, or external-source PivotTables
Use this method when Excel does not allow typing over the field name or restores the original name after a refresh.
Rename and manage PivotTable fields with WPS Spreadsheet
WPS Spreadsheet provides familiar PivotTable tools for organizing data and updating editable field captions. For PivotTables built from local worksheet data, you can rename displayed fields and review the results in your pivot report with an Excel-compatible workflow.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Open, and select the Excel .xlsx or .xls workbook containing the PivotTable.
- 2. Select the PivotTable field: Click inside the PivotTable, then select the field heading or caption you want to update.
- 3. Enter the new caption: Type the replacement field name in the selected heading and press Enter to apply it when the field is editable.
- 4. Refresh and verify the report: Use the PivotTable tools to refresh the report if required, then check that the revised caption appears in the PivotTable output.
Frequently Asked Questions
Why can I not rename a field in my Excel PivotTable?
The field may come from an OLAP cube, Data Model, Power Query query, or external connection. In these cases, rename the field in the source model, query, or database, then use PivotTable Analyze > Refresh.
Can I rename a PivotTable field without changing the source column name?
Yes, for many standard PivotTables based on an Excel range or table. Click the field heading, type a unique custom caption, and press Enter. The original worksheet column heading can remain unchanged.
Why does Excel say that a PivotTable field name already exists?
Excel requires PivotTable field captions to be unique. Edit the heading and add a different word, qualifier, or character before pressing Enter.
Will renaming a PivotTable field update my PivotChart?
A PivotChart linked to the PivotTable normally uses the same field captions. After renaming the field, click the PivotChart to confirm its axis, legend, or filter label has updated.
