Oct 29 2019 02:40 AM - edited Oct 29 2019 08:37 AM
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
Oct 31 2019 01:21 AM
Oct 31 2019 01:58 AM
@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
Oct 31 2019 02:53 AM
Oct 31 2019 03:16 AM
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
Oct 31 2019 04:00 AM