PivotTable.RowAxisLayout method (Excel)
This method is used for simultaneously setting layout options for all existing PivotFields.
Syntax
expression.RowAxisLayout (RowLayout)
expression A variable that represents a PivotTable object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
RowLayout | Required | XlLayoutRowType | Specifies the type of layout row. 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.
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for