SOLVED
Home

Excel Pivot Table No Fields in the List

%3CLINGO-SUB%20id%3D%22lingo-sub-313133%22%20slang%3D%22en-US%22%3EExcel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313133%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20trouble%20creating%20a%20pivot%20table%20because%20I%20can't%20figure%20out%20why%26nbsp%3Bthere%20are%20no%26nbsp%3Bfields%20are%20showing%20up%20in%20my%20field%20list.%20I've%20checked%20my%20data%20source%20and%20it%20includes%20my%20column%20headings%20on%20the%20data%20source%20table.%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-313133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epivot%20table%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313244%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313244%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313148%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313148%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20on%20the%20gear%20icon%20and%20change%20the%20setting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1106564%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1106564%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Lewin%20what%20configuration%20I%20need%20to%20change.%20I%20have%20the%20same%20issue%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1106633%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1106633%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F517375%22%20target%3D%22_blank%22%3E%40Johny_1975%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20the%20five%20options%20to%20see%20which%20one%20suits%20your%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1107753%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20No%20Fields%20in%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1107753%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20worked%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Kurt8
New 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?

 

 

5 Replies
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 

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Problems using Pivot tables in Excel 16.25 on Mac
jeromepineau in Excel on
0 Replies