PIVOT.FIELD.UNGROUP macro

Ungroups all selected groups within a PivotTable report.

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 report. Similarly, if the last group in a Parent field is ungrouped, the entire field will be removed from the PivotTable report.

Related Functions

PIVOT.ADD.DATA   Adds a field to a PivotTable report as a data field

PIVOT.ADD.FIELDS   Adds fields to a PivotTable report

PIVOT.FIELD   Pivots fields within a PivotTable report

PIVOT.FIELD.GROUP   Creates groups within a PivotTable report

PIVOT.FIELD.PROPERTIES   Changes the properties of a field inside a PivotTable report

PIVOT.ITEM   Moves an item within a PivotTable report

PIVOT.ITEM.PROPERTIES   Changes the properties of an item within a header field

PIVOT.REFRESH   Refreshes a PivotTable report

PIVOT.SHOW.PAGES   Creates new sheets in the workbook containing the active cell

PIVOT.TABLE.WIZARD   Creates an empty PivotTable report

Return to index