Fix an Excel PivotTable Field List That Does Not Refresh
Question details
Restore the Excel PivotTable Field List so it shows fields promptly after they are dragged into an area.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A user drags fields into the Rows, Columns, Values, or Filters areas of a PivotTable.
- Observed behavior
- The dragged fields may not appear in the Field List until it is closed and reopened.
Open the affected workbook and select the PivotTable to display the Field List. Note which field and area reproduce the issue, and check File > Account for your Office product information.
Update Microsoft 365 and retest the PivotTable Field List
Use this approach when the Field List display may be affected by an outdated Office build.
In Excel or another Office application, select File > Account.
Under Product Information, select Update Options > Update Now and follow the prompts. If update options are unavailable, contact your organization's Office administrator.
Close and reopen Excel, select the PivotTable, and drag a field into an area in the Field List. Check whether it appears without closing and reopening the list.

Document the issue for further investigation
Use this approach if the Field List still fails to update after Office is updated and Excel is restarted.
Work with PivotTables in WPS Spreadsheets
WPS Office is a free, lightweight alternative for spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files, though it does not fix Excel's Field List issue.

Frequently Asked Questions
How do I update Excel for Microsoft 365?
In Excel, select File > Account > Update Options > Update Now. Restart Excel after the update and test the PivotTable again.
Why does the field appear only after I reopen the Field List?
The Field List display may not be updating immediately. An outdated Office build can be a factor, so install available updates and retest before gathering information for support.
Will refreshing the PivotTable data fix the Field List display?
Not necessarily. PivotTable data refresh updates the underlying data, while this issue concerns whether the Field List displays a dragged field promptly.
What should I send support if the problem continues?
Provide the steps to reproduce the issue, a sample workbook without sensitive information, screenshots of File > Account, and the date the issue began. Include whether it started after an Office update.




