Pivot Table Issues

How to Fix Power Pivot Measure Name Not Updating in a PivotTable

Ayan MasoodAyan Masood Nov 13, 2026 868 views

Question details

The user needs to make a renamed Power Pivot measure appear correctly in a PivotTable that still shows the previous measure name.

How to Fix Power Pivot Measure Name Not Updating in a PivotTable
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Pivot and rename the measure

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.

2
Refresh the PivotTable

Return to the worksheet, right-click any cell inside the PivotTable, and choose Refresh from the context menu.

Rename the measure in Power Pivot and refresh the PivotTable
Measure name updated: The PivotTable should now show the new measure name after the refresh.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the WPS Office download page and click Download WPS Office Free.
  2. 2. Open an Excel workbook: Launch WPS Spreadsheets, click Open, and select the .xlsx file you want to work with.
  3. 3. Use PivotTable features: Select your data, go to Insert > PivotTable in WPS Spreadsheets, and create a PivotTable report.
Opens and saves .xlsx workbooks while preserving your data, formulas, and workbook structure.Familiar ribbon and spreadsheet tools reduce migration effort from Microsoft Excel.Includes PivotTable capabilities in WPS Spreadsheets for common data analysis tasks.Free and lightweight installation with no subscription or activation cost.
microsoft office alternative - wps office

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.