| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.RowAxisLayout method (Excel) |
vbaxl10.chm235166 |
|
|
41a8a3bb-252a-7598-b559-d75dc1e10bc1 |
05/09/2019 |
medium |
This method is used for simultaneously setting layout options for all existing PivotFields.
expression.RowAxisLayout (RowLayout)
expression A variable that represents a PivotTable object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| RowLayout | Required | XlLayoutRowType | Specifies the type of layout row. Can be xlCompactRow, xlTabularRow, or xlOutlineRow. |
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.
[!includeSupport and feedback]