Home

, Excel Pivot Table not showing 'Show Detail'

%3CLINGO-SUB%20id%3D%22lingo-sub-961984%22%20slang%3D%22en-US%22%3E%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-961984%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20poster%2C%20so%20happy%20for%20any%20feedback%20about%20my%20post%20and%20any%20help%20is%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20happily%20being%20drilling%20into%20my%20data%20within%20Excel%20Pivot%20Tables%2C%20however%20for%20no%20apparent%20reason%20it%20is%20greyed%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20happens%20across%20all%20different%20spreadsheets%20within%20my%20organisation%20and%20for%20each%20user%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20checked%20the%20Pivot%20Table%20Options%2C%20'Enable%20Show%20Details'%20option%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20see%20anything%20else%20that%20would%20stop%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%23pivottable%20%23excel%26nbsp%3B%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-961984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-967760%22%20slang%3D%22en-US%22%3ERe%3A%20%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-967760%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20you%20add%20a%20screenshot%20of%20you%20Pivot%20Table%20Fields%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20drilling%20down%20in%20a%20Pivot%20Table%20or%20a%20Pivot%20Chart%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-967827%22%20slang%3D%22en-US%22%3ERe%3A%20%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-967827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20response%20Wyn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20'double%20click'%20into%20a%20pivot%20table%20and%20it%20will%20show%20the%20data%20and%20is%20a%20work%20around%20at%20the%20moment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20the%20pivot%20chart%20i'm%20having%20the%20issue%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20added%20screenshots%20of%20the%20data%20(removing%20confidential%20info)%20-%20i%20had%20to%20do%20it%20over%202%20screenshots%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968019%22%20slang%3D%22en-US%22%3ERe%3A%20%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968019%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F435395%22%20target%3D%22_blank%22%3E%40P_J_Lycett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20meant%20a%20screenshot%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F152268i60E019BF995A395B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968083%22%20slang%3D%22en-US%22%3ERe%3A%20%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968083%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F435395%22%20target%3D%22_blank%22%3E%40P_J_Lycett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20sounds%20like%20a%20BUG%2C%26nbsp%3B%20I've%20responded%20here...%20and%20will%20flag%20up%20with%20the%20Excel%20Team.%26nbsp%3B%20%26nbsp%3BPlease%20click%20on%20File%20%26gt%3B%20Feedback%20and%20send%20a%20Frown%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Foffice-365-excel-unable-to-select-pivot-chart-show%2F4747ff11-5ec0-43cb-aa96-82629a4ed01d%3Fpage%3D2%26amp%3BrtAction%3D1572516647735%26amp%3Btm%3D1572516825659%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Foffice-365-excel-unable-to-select-pivot-chart-show%2F4747ff11-5ec0-43cb-aa96-82629a4ed01d%3Fpage%3D2%26amp%3BrtAction%3D1572516647735%26amp%3Btm%3D1572516825659%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968139%22%20slang%3D%22en-US%22%3ERe%3A%20%2C%20Excel%20Pivot%20Table%20not%20showing%20'Show%20Detail'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20Wyn%2C%20I've%20attached%20a%20screenshot%20and%20sent%20in%20a%20'Frown'%20to%20Microsoft%3C%2FP%3E%3C%2FLINGO-BODY%3E
P_J_Lycett
New Contributor

Hi 

 

First time poster, so happy for any feedback about my post and any help is greatly appreciated.

 

I've happily being drilling into my data within Excel Pivot Tables, however for no apparent reason it is greyed out. 

 

This happens across all different spreadsheets within my organisation and for each user ?

 

I've checked the Pivot Table Options, 'Enable Show Details' option 

 

I can't see anything else that would stop me

 

#pivottable #excel 

 

 

5 Replies
Highlighted
Hi

Could you add a screenshot of you Pivot Table Fields

Are you drilling down in a Pivot Table or a Pivot Chart?
Highlighted

@Wyn Hopkins Thanks for the response Wyn

 

I can 'double click' into a pivot table and it will show the data and is a work around at the moment.

 

It's the pivot chart i'm having the issue with.

 

I've added screenshots of the data (removing confidential info) - i had to do it over 2 screenshots

Highlighted

Sorry @P_J_Lycett 

 

I meant a screenshot like this

clipboard_image_0.png

Highlighted

Hi @P_J_Lycett 

 

This sounds like a BUG,  I've responded here... and will flag up with the Excel Team.   Please click on File > Feedback and send a Frown

 

https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-excel-unable-to-select-pivot-chart...

Highlighted

@Wyn Hopkins 

 

Thanks again Wyn, I've attached a screenshot and sent in a 'Frown' to Microsoft

Related Conversations
Userform/Command Button to Appear in New Worksheet
Mr_Buttons in Excel on
0 Replies
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies
FREQUENCY
enaugle in Excel on
3 Replies