PivotTable.LayoutRowDefault Property

Excel Developer Reference

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