PivotField.LayoutForm procedure builder

PivotField.LayoutForm (Excel)

Returns or sets the way the specified PivotTable items appear—in table format or in outline format.

xlOutline - The LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report, xlTabular - Default.

For xlOutline, the LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report. xlTabular is the default. You can set this property for any PivotTable field; however, the formatting appears only if the specified field is a row field other than the innermost (lowest-level) row field. For non-OLAP data sources, the value of this property doesn't change when the field is rearranged or when it is added to or removed from the PivotTable report.

ActiveCell.PivotField.LayoutForm = xlOutline