How to Fix Power Pivot Measure Name Not Updating in a PivotTable
Question details
The user needs to make a renamed Power Pivot measure appear correctly in a PivotTable that still shows the previous measure name.

- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- A user renamed a measure in Power Pivot but an existing PivotTable continues to display the old measure name.
- Observed behavior
- The PivotTable keeps the old measure name because it retains cached field information or has not been refreshed after the measure was renamed.
Open the workbook in Excel, enable the Power Pivot add-in if it is not already visible on the ribbon, and confirm the PivotTable is connected to the same Power Pivot data model where the measure was renamed.
Rename the measure in Power Pivot and refresh the PivotTable
Use this first because it fixes most cases where the PivotTable simply has not refreshed after the measure name change.
In Excel, go to the Power Pivot tab, click Manage to open the Power Pivot window, select the measure in the calculation area or measure list, and rename it using the measure edit dialog or formula bar.
Return to the worksheet, right-click any cell inside the PivotTable, and choose Refresh from the context menu.

Remove the old measure and add the renamed one in the Values area
Use this if a simple refresh does not update the cached measure name in the PivotTable Fields pane.
Clear cached field information or create a new PivotTable
Use this when the old name remains after the previous steps because the workbook still stores stale field metadata.
WPS Office: A Free, Lightweight Excel Alternative for PivotTable Work
WPS Office provides a free, lightweight Office alternative with familiar spreadsheets, Excel file compatibility, and a user-friendly interface, so you can handle everyday PivotTable reports without a subscription—even though it does not include the Power Pivot add-in.
- 1. Download WPS Office: Go to the WPS Office download page and click Download WPS Office Free.
- 2. Open an Excel workbook: Launch WPS Spreadsheets, click Open, and select the .xlsx file you want to work with.
- 3. Use PivotTable features: Select your data, go to Insert > PivotTable in WPS Spreadsheets, and create a PivotTable report.

Frequently Asked Questions
Why does my PivotTable still show the old Power Pivot measure name after I rename the measure?
A PivotTable caches field information, so it may not pick up a measure name change until you right-click the PivotTable and choose Refresh. If the old name remains, remove the measure from the Values area and add it again.
Does WPS Office support Power Pivot?
No, Power Pivot is a Microsoft Excel add-in. WPS Office does not include Power Pivot, but WPS Spreadsheets can open Excel .xlsx files and provides PivotTable tools for common data analysis.
Can I clear the PivotTable cache without deleting the PivotTable?
You can close and reopen the workbook, then refresh the PivotTable. If Excel still stores the old field name, rebuild the PivotTable from Insert > PivotTable using the same data model.
Will re-adding the measure change my PivotTable values?
Re-adding the renamed measure should keep the same calculation logic and values, but the PivotTable will display the new measure name instead of the old one.




