Edit

XlPivotFormatType enumeration (Excel)

  • Article

Specifies the type of report formatting to be applied to the specified PivotTable report.

Name Value Description
xlPTClassic 20 PivotTable classic format.
xlPTNone 21 Does not apply formatting to the PivotTable report.
xlReport1 0 Use the xlReport1 formatting for the PivotTable.
xlReport10 9 Use the xlReport10 formatting for the PivotTable.
xlReport2 1 Use the xlReport2 formatting for the PivotTable.
xlReport3 2 Use the xlReport3 formatting for the PivotTable.
xlReport4 3 Use the xlReport4 formatting for the PivotTable.
xlReport5 4 Use the xlReport5 formatting for the PivotTable.
xlReport6 5 Use the xlReport6 formatting for the PivotTable.
xlReport7 6 Use the xlReport7 formatting for the PivotTable.
xlReport8 7 Use the xlReport8 formatting for the PivotTable.
xlReport9 8 Use the xlReport9 formatting for the PivotTable.
xlTable1 10 Use the xlTable1 formatting for the PivotTable.
xlTable10 19 Use the xlTable10 formatting for the PivotTable.
xlTable2 11 Use the xlTable2 formatting for the PivotTable.
xlTable3 12 Use the xlTable3 formatting for the PivotTable.
xlTable4 13 Use the xlTable4 formatting for the PivotTable.
xlTable5 14 Use the xlTable5 formatting for the PivotTable.
xlTable6 15 Use the xlTable6 formatting for the PivotTable.
xlTable7 16 Use the xlTable7 formatting for the PivotTable.
xlTable8 17 Use the xlTable8 formatting for the PivotTable.
xlTable9 18 Use the xlTable9 formatting for 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.