Formula guide · Excel and Google Sheets · Updated May 13, 2026
Pivot Table Field List Missing
Bring back a missing pivot table field list in Excel or Google Sheets.
Quick Answer
The pivot field list usually disappears because the pivot table is not selected or the field list panel was closed.
Copyable Formula
No formula required. Select the pivot table and reopen the field list.Syntax
Select the pivot table, then reopen the field list or editor.Excel and Google Sheets
Worked Example
| Symptom | Fix |
|---|---|
| No field list | Click inside the pivot table |
| Panel closed | Reopen field list/editor |
| Protected sheet | Check editing permissions |
Result: Once the pivot table is selected and the editor is open, the fields can be changed again.
Steps
- Click inside the pivot table first.
- Open the pivot table field list or editor from the menu.
- Check whether the sheet is protected or read-only.
- Refresh the pivot table if fields still look stale.
Common Mistakes
- Looking for the field list while a normal cell is selected.
- Rebuilding the pivot before checking whether the panel is simply hidden.
- Ignoring sheet protection or view-only access.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.