Fix Excel PivotTable Calculated Fields Disappearing After Refresh
Question details
Determine why calculated fields disappear from an Excel PivotTable after source rows are added and the PivotTable is refreshed.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user adds rows to the PivotTable source data and refreshes the PivotTable.
- Observed behavior
- Calculated fields may disappear after the refresh.
Identify the affected PivotTable and note whether it worked correctly before. Record the calculated field names and formulas if they are still available.
Check the PivotTable and collect refresh details
Use these checks to determine whether a field was removed, hidden from the layout, or affected by a source change.
Click the PivotTable, then select PivotTable Analyze > Field List. Look for the calculated field in the list and check whether it is still placed in the Values area.
With the PivotTable selected, open PivotTable Analyze > Fields, Items & Sets > Calculated Field. Check the Name list for the missing field and review its formula if it is available.
Select PivotTable Analyze > Change Data Source and check whether the source range includes the new rows. Note any change to the source before refreshing again.
Capture screenshots of the source rows, the refresh action under PivotTable Analyze > Refresh, and the resulting field list. Note whether the workbook previously worked as expected.
Open File > Account, where available, and record the Office version, update channel, and build shown under Product Information.

Restore a calculated field when its formula is known
Use this option if the field is absent from the calculated-field list and you know its original formula.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Microsoft Office files. It can make moving everyday spreadsheet work easier, although it does not fix Excel's refresh behavior.

Frequently Asked Questions
How can I tell if the calculated field still exists?
Select the PivotTable and open PivotTable Analyze > Fields, Items & Sets > Calculated Field. Look for the field in the Name list. Also check PivotTable Analyze > Field List to see whether it is available but no longer in Values.
Will changing the source range fix the disappearing field?
Not necessarily. Use PivotTable Analyze > Change Data Source to verify that the range includes the new rows, but the cause of a disappearing calculated field may require further investigation.
Can I recreate a missing calculated field?
If you know its original formula and the PivotTable supports calculated fields, select PivotTable Analyze > Fields, Items & Sets > Calculated Field, then enter the name and formula. Refresh afterward to see whether it remains.
What information should I provide to support?
Share the workbook privately, screenshots of the refresh steps and result, whether it worked previously, and the Office version and build. On supported versions, find version details under File > Account.




