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?
Hi, please me too. I dont find any macro. Is there also some functionality, not only collaps / expanse all fields, but only some fileds starting on the column, I actually use? Something similar as it was possible in qlik view???
Hi Bill, I have many sheets with many pivot tables. I want to be sure that when I save the qvw that all are fully collapsed and ready for users. Found the macro below in another post. This works to change the AlwaysFullyExpanded option to false but does not actually Collapse All. The saved qvw retains expanded columns and they appear like this when users open the model from the access point. Is there a solution for this ?
Function CollapsePivot (objectID)
Set chart = ActiveDocument.GetSheetObject(objectID)