Pivot Table Recommendations List

%3CLINGO-SUB%20id%3D%22lingo-sub-2466455%22%20slang%3D%22en-US%22%3EPivot%20Table%20Recommendations%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466455%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20to%20utilize%20a%20pivot%20table%20but%20it%20appears%20the%20recommended%20table%20list%20will%20not%20show%20up.%20I%20can%20go%20back%20to%20a%20different%20file%20and%20it%20shows%20up.%20Even%20when%20I%20copy%20the%20other%20table%20into%20the%20current%20excel%20sheet%20the%20recommended%20list%20appears%20but%20only%20for%20that%20table.%20When%20I%20try%20to%20click%20on%20the%20recommended%20pivot%20table%20from%20my%20new%20table%20it%20gives%20an%20error%20message%20that%20there%20are%20too%20many%20blank%20cells.%20anyone%20have%20this%20problem%20or%20have%20a%20fix%20for%20it.%20I%20have%20some%20snapshots%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20Version%202104%3C%2FP%3E%3CP%3EOS%20Windows%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ChrisSprague_0-1624296664746.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290316i29F977A92CFEDDAF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ChrisSprague_0-1624296664746.png%22%20alt%3D%22ChrisSprague_0-1624296664746.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ChrisSprague_1-1624296683057.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290319iB972F720515E7A52%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ChrisSprague_1-1624296683057.png%22%20alt%3D%22ChrisSprague_1-1624296683057.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2466455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466820%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Recommendations%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084420%22%20target%3D%22_blank%22%3E%40ChrisSprague%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20data%20in%20your%20table%20are%20not%20suitable%20for%20a%20pivot%20table%20since%20the%20values%20in%20the%20first%20column%20are%20all%20different.%20A%20pivot%20table%20always%20summarizes%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi I am trying to utilize a pivot table but it appears the recommended table list will not show up. I can go back to a different file and it shows up. Even when I copy the other table into the current excel sheet the recommended list appears but only for that table. When I try to click on the recommended pivot table from my new table it gives an error message that there are too many blank cells. anyone have this problem or have a fix for it. I have some snapshots below. 

 

Excel Version 2104

OS Windows 10

 

 

 

ChrisSprague_0-1624296664746.png

 

 

ChrisSprague_1-1624296683057.png

 

1 Reply

@ChrisSprague 

The data in your table are not suitable for a pivot table since the values in the first column are all different. A pivot table always summarizes data.