The vba i found on this site for 'Making all pivot tables on one sheet mimic each other in terms of rows expanding and collapsing' works fantastic for a standard pivot table in excel, however, it doesn't work with power pivot, how is this coding modified for power pivot?
Asked
Active
Viewed 26 times
0
-
Couldn't you use slicers instead of code? [Contexturesblog](https://contexturesblog.com/archives/2011/03/07/filter-multiple-pivot-tables-with-excel-2010-slicers/) has pretty good instructions on how to do it. – Darren Bartrup-Cook Mar 27 '20 at 12:14
-
No, i'm using slicers, but for what i need to do the tables need to open to the next level together. The code on here is perfect for the principle but also have connected tables so has to be in power pivot. – Glen Mar 27 '20 at 12:58