Apr 02 2022 09:41 PM
Apr 07 2022 07:59 PM
Apr 08 2022 12:20 AM
Apr 08 2022 03:04 AM
Do you have multiple monitors? If so, try disconnecting all except the main one temporarily to see if the field list reappears on the main monitor.
Something else to try:
CommandBars("PivotTable Field List").Position = 2
Apr 08 2022 04:02 AM
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.
Apr 08 2022 04:19 AM
Apr 08 2022 04:45 AM
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.
Apr 08 2022 05:12 AM
Apr 08 2022 05:55 AM