SOLVED

Excel Pivot Table No Fields in the List

Copper Contributor

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
best response confirmed by Kurt8 (Copper Contributor)
Solution

Hello

 

Click on the gear icon and change the setting.

 

Thanks!

Hi Lewin what configuration I need to change. I have the same issue @Detlef Lewin 

@Johny_1975 

Try the five options to see which one suits your need.

 

thank you 

it worked

 

@Detlef Lewin 

 

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!

1 best response

Accepted Solutions
best response confirmed by Kurt8 (Copper Contributor)
Solution

Hello

 

Click on the gear icon and change the setting.

 

View solution in original post