PivotTable.LayoutRowDefault property (Excel)

This property specifies the layout settings for PivotFields when they are added to the PivotTable for the first time. Read/write XlLayoutRowType.

Syntax

expression.LayoutRowDefault

expression A variable that represents a PivotTable object.

Remarks

XlLayoutRowType can be xlCompactRow, xlTabularRow, or xlOutlineRow.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.