Macro Sheets Only
Ungroups all selected groups within a PivotTable.
Syntax
PIVOT.FIELD.UNGROUP( )
Remark
If the active cell is on a field header, then all the groups in that field are ungrouped and the field will be removed from the PivotTable. Similarly, if the last group in a Parent field is ungrouped, the entire field will be removed from the PivotTable.
Related Functions
PIVOT.ADD.DATA Adds a field to a PivotTable as a Data Field
PIVOT.ADD.FIELDS Adds fields to a PivotTable
PIVOT.FIELD Pivots fields within a PivotTable
PIVOT.FIELD.GROUP Creates groups within a PivotTable
PIVOT.FIELD.PROPERTIES Changes the properties of a field inside a PivotTable
PIVOT.ITEM Moves an item within a PivotTable
PIVOT.ITEM.PROPERTIES Changes the properties of an item within a header field
PIVOT.REFRESH Refreshes a PivotTable
PIVOT.SHOW.PAGES Creates new sheets in the workbook containing the active cell
PIVOT.TABLE.WIZARD Creates an empty PivotTable
List of Command-Equivalent Functions