Forum Discussion

Kurt8's avatar
Kurt8
Copper Contributor
Jan 10, 2019
Solved

Excel Pivot Table No Fields in the List

Hello,

 

I'm having trouble creating a pivot table because I can't figure out why there are no fields are showing up in my field list. I've checked my data source and it includes my column headings on the data source table. Any ideas?

 

 

6 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello

     

    Click on the gear icon and change the setting.

     

    • Paul Anderson's avatar
      Paul Anderson
      Copper Contributor

       

      Thank you, that worked!

      It was affecting every workbook I opened and tried to do a Pivot Table in.

      Once this one had the 'gear' opened, and a PivotTable Fields selection for 

      one of the layouts, then this file and the other workbooks, all had the Pivot 

      Table fields being populated.

      Thank you!

Resources