PivotTable.LayoutRowDefault (Excel)

This property specifies the layout settings for PivotFields when they are added to the PivotTable for the first time. Possible return values are xlCompactRow - Compact Row, xlOutlineRow - Outline Row, xlTabularRow - Tabular Row.

XlLayoutRowType can be xlCompactRow, xlTabularRow, or xlOutlineRow.

ActiveCell.PivotTable.LayoutRowDefault = xlCompactRow