Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotTable.RowAxisLayout Method

Office 2007
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

NameRequired/OptionalData TypeDescription
RowLayoutRequiredXlLayoutRowTypeCan 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.




Community Additions

Show: