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.

Version Information

Version Added: Excel 2007

Syntax

expression .LayoutRowDefault

expression A variable that represents a PivotTable object.

Remarks

xlLayoutRowType can be either xlCompactRow, xlTabularRow, or xlOutlineRow.

See Also

Concepts

PivotTable Object

PivotTable Object Members