Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way for collapsing and expanding the levels in a pivot table in their entirity without having to right click and then expand/collapse all?
Thanks
You do not need the print screens as it is explained : in a few words ==> deal with bookmarks
If possible ,instead of Macros
simply put 2 charts in a Container
1 is Expanded manner
2nd is Collapsed manner
Hi Kevin,
My Hide/Unhide solution below don't satisfy you neither ?