Forum Discussion
Manuel_John
Apr 03, 2022Copper Contributor
Field List in Pivot table not showing
Field list is not showing in my pivot table even after clicking show field list. I am using office 365.
28 Replies
Sort By
- Pierre_AndreCopper Contributor1. Right-click on the Pivot Table/Chart: You can also right-click on any cell within your pivot table or on your pivot chart.
2. Show Field List: From the context menu that appears, select "Show Field List".
THIS IS THE ANSWER. FORGET THE RESTDid you read the thread? It doesn't work with some plugins installed, but works in safe mode.
- Mike_Martin_Copper ContributorI know this post is old, but I wanted to add to this post as I experienced the exact same issue, but this post did not have the permanent fix. So I found the solution elsewhere. If you cannot view the Pivot Table Field List in normal mode, but are able to view the Pivot Table Field List in safe mode (hold ctrl while opening excel), then this solution should work for you.
Perform the below steps to delete and recreate the configuration file "Excel15.xlb" within Excel's roaming profile.
Close all Excel Files
Navigate to C:\Users\[Username]\AppData\Roaming\Microsoft\Excel folder.
Delete the Excel15.xlb file (or move to another folder as a backup)
Open up Excel and a new Excel15.xlb should be created in the roaming folder
In Excel, you should now be able to view the Pivot Table Field List.
If you do not see the field list, ensure that the "Show Field List" option is selected by right clicking in the pivot table
If you attempt this solution, be sure to make a backup before deleting any files.- smathisonCopper Contributor
I needed this fix today! It was driving me crazy that the Field List would not show. Very strange, but thanks for the tip!
- AlisonGunnels1Copper Contributor
Worked perfectly! Thank you!
- Vlad_SilvestruCopper ContributorThanks a lot! Worked perfectly for me
Could you attach a copy of the workbook, or make it available through OneDrive, Google Drive, Dropbox, ...?
- Manuel_JohnCopper Contributor
How can I attach the sheet, I can't see any link to attach?
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.