Share via


PivotTable.RowAxisLayout Method (Excel)

This method is used for simultaneously setting layout options for all existing PivotFields.

Version Information

Version Added: Excel 2007

Syntax

expression .RowAxisLayout(RowLayout)

expression A variable that represents a PivotTable object.

Parameters

Name

Required/Optional

Data Type

Description

RowLayout

Required

XlLayoutRowType

Can be xlCompactRow, xlTabularRow, or xlOutlineRow.

Remarks

This method is atomic so it makes sure that if layout options cannot be set on any PivotField, the layout options of none of the fields will change and no change is made to the PivotTable.

See Also

Concepts

PivotTable Object

PivotTable Object Members