Forum Discussion

Maddis1234's avatar
Maddis1234
Copper Contributor
Mar 27, 2024

Not allowed to rename a field i pivot table/chart

Hi,

I'm following the instruction on Microsoft Support website to rename a field in a PivotTable/PivotChart but I'm getting error that I'm not allowed to rename the field.

 

How can I resolve this matter?

 

excel
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    If your PivotTable is connected to an OLAP cube or external data source, you may not be able to rename fields directly in the PivotTable. You need to modify the field name in the data source or use Power BI for more flexibility. For standard PivotTables using an Excel table or range, renaming should generally be possible.

Resources