Forum Discussion

Manuel_John's avatar
Manuel_John
Copper Contributor
Apr 03, 2022

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

  • Pierre_Andre's avatar
    Pierre_Andre
    Copper Contributor
    1. 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 REST
  • Mike_Martin_'s avatar
    Mike_Martin_
    Copper Contributor
    I 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.
    • smathison's avatar
      smathison
      Copper 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! 

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Manuel_John 

        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.

Resources