![auto grouping in excel 365 not working auto grouping in excel 365 not working](https://www.gottabemobile.com/wp-content/uploads/How-to-Use-Microsoft-Office-on-iPhone-20-e1458057486464.jpg)
If you want to expand to show all groupings, expand the row and column levels to number 8 like in the following VBA code. Ws.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1
AUTO GROUPING IN EXCEL 365 NOT WORKING CODE
Use these lines of code for collapsing everything to grouping level 1 (minimum). The following two VBA macros can either collapse all groupings or expand them. Method 1: Use a VBA macro for collapsing or expanding grouping
![auto grouping in excel 365 not working auto grouping in excel 365 not working](https://www.pivot-table.com/wp-content/uploads/2019/05/pivotdategrouping01b.jpg)
There are two methods for achieving this. For example, before sending out a workbook, you might want to close all groups so that the workbook looks more “tidy” on the first impression. In many cases you want to collapse all groupings or expand them.