S Shay A Member Sep 10, 2018 #1 Hi, Is it possible to set a pivot table expansion as an event so that every time a user use the + sign button all of the columns are adjusted properly? I am referring to an expansion and not to refreshing. TY!
Hi, Is it possible to set a pivot table expansion as an event so that every time a user use the + sign button all of the columns are adjusted properly? I am referring to an expansion and not to refreshing. TY!
p45cal Well-Known Member Sep 10, 2018 #2 The default is for it to do this. Check under PivotTable Options that you have Autofit column widths on update ticked:
The default is for it to do this. Check under PivotTable Options that you have Autofit column widths on update ticked:
S Shay A Member Sep 10, 2018 #3 yes but this is on update, I mean when you expand the pivot table using the plus sign.
p45cal Well-Known Member Sep 10, 2018 #4 Yes, I undersood that. My response remains the same. I tried it. Update is not the same as Refresh
