Pivot Table Issues

Fix Excel PivotTable Calculated Fields Disappearing After Refresh

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

Determine why calculated fields disappear from an Excel PivotTable after source rows are added and the PivotTable is refreshed.

Fix Excel PivotTable Calculated Fields Disappearing After Refresh
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.
Before you start

Identify the affected PivotTable and note whether it worked correctly before. Record the calculated field names and formulas if they are still available.

Solution 1Recommended

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.

1
Check the field list

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.

2
Inspect the calculated field

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.

3
Verify the source

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.

4
Document the issue

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.

5
Record the Office version

Open File > Account, where available, and record the Office version, update channel, and build shown under Product Information.

Check the PivotTable and collect refresh details
If the cause remains unclear: Share the workbook or a download link and the recorded details through a private support channel. Remove or protect sensitive information before sharing.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesAnalyze spreadsheet data with PivotTable toolsUse a familiar interface for a smoother move from OfficeAccess a lightweight office suite for free
microsoft office alternative - wps office

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.