, Excel Pivot Table not showing 'Show Detail'

[P_J_Lycett]

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 

[#2]

Hi

Could you add a screenshot of you Pivot Table Fields

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

[#3]

@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

[#4]

Sorry @P_J_Lycett 

I meant a screenshot like this

[#5]

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...

[#6]

@Wyn Hopkins 

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