5 Replies Latest reply: Oct 9, 2015 12:17 PM by Peter Cammaert RSS

    how to get the expand status when the pivot table is expand

    Zhihong He

      Hi, all,

      Got a problem to catch the status when ANY ROW is expand in a pivot table.  The table is originally collapsed, and when the table is in expand status, we would like to hide some expression columns that only make sense when  the table is in collapse status.

       

      I know how to use the macro and variable to expand all/ collapse all.  But have no idea how to catch the status when the pivot table is expand.

       

      Any one can help?

       

      Thanks very much