Apr 02 2022 09:41 PM
Field list is not showing in my pivot table even after clicking show field list. I am using office 365.
Apr 03 2022 04:08 AM
Could you attach a copy of the workbook, or make it available through OneDrive, Google Drive, Dropbox, ...?
Apr 05 2022 07:42 PM
How can I attach the sheet, I can't see any link to attach?
Apr 06 2022 03:05 AM
In that case, please upload it to a cloud service such as OneDrive or Google Drive, obtain a link to the uploaded workbook and post the link in a reply.
Apr 07 2022 07:59 PM
Apr 08 2022 12:16 AM
Apr 08 2022 12:20 AM
Apr 08 2022 12:24 AM
See the screen shot the pivot table which didn't show the fields though I have selected the field.
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 03:56 AM
Apr 08 2022 03:59 AM
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:07 AM
Apr 08 2022 05:08 AM
I'm afraid I'm out of ideas. You might try repairing your Office installation.
Apr 08 2022 05:12 AM
Apr 08 2022 05:52 AM
If reinstalling didn't help, I don't think repairing will help either. It's a weird problem!
Apr 08 2022 05:55 AM
Jul 14 2023 08:43 AM