XlPivotFormatType enumeration (Excel)
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. |
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.