| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.PageFieldOrder property (Excel) |
vbaxl10.chm235119 |
|
|
0c8a6473-f2ee-f357-b840-aaf61cee1fa0 |
05/09/2019 |
medium |
Returns or sets the order in which page fields are added to the PivotTable report's layout. Can be one of the following XlOrder constants: xlDownThenOver or xlOverThenDown. The default constant is xlDownThenOver. Read/write Long.
expression.PageFieldOrder
expression A variable that represents a PivotTable object.
This example causes the PivotTable report to draw three page fields in a row before starting a new row.
With Worksheets(1).PivotTables("Pivot1")
.PageFieldOrder = xlOverThenDown
.PageFieldWrapCount = 3
End With[!includeSupport and feedback]