Forum Discussion
Field List in Pivot table not showing
Quit Excel completely.
Hold down the left Ctrl key while you open Excel again.
Excel should ask whether you want to start it in safe mode. Click Yes.
Open the workbook from within Excel.
Can you display the field list now?
If not, try repairing Office.
- Thank you very much for your help, much appreciated. At least I can workout in safe mode, that's great.
If reinstalling didn't help, I don't think repairing will help either. It's a weird problem!
- Last week I uninstall Office 365 and reinstall the same, that doesn't helps. So you suggesting to repair the Office Installation?
I'm afraid I'm out of ideas. You might try repairing your Office installation.
- I cleared all the Add-ins, but that doesn't works. So what I will do?
If it works in safe mode, the most probable culprit is an add-in.
Select File > Options, then select Add-ins in the navigation pane on the left.
Make a note of which add-ins are listed under Active Application Add-ins.
Near the bottom of the dialog you will see a drop-down list next to Manage.
Select Excel Add-ins from the Manage drop-down, then click Go...
Clear all ticked check boxes, then click OK.
Repeat for all other types in the Manage drop-down (COM Add-ins etc.)
When you're done. check whether you can display the Field List.
If not, this hasn't worked. Reactivate the original add-ins.
But if you see the Field List, now comes the tedious part.
One by one, reactivate the add-ins, and after each one check whether the Field List is still displayed.
If not, you know that the last add-in that you reactivated is the culprit. Deactivate that one again.