This documentation is archived and is not being maintained.

XlPivotFormatType Enumeration

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

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlPTClassic20PivotTable classic format.
xlPTNone21Does not apply formatting to the PivotTable report.
xlReport10Use the xlReport1 formatting for the PivotTable.
xlReport109Use the xlReport10 formatting for the PivotTable.
xlReport21Use the xlReport2 formatting for the PivotTable.
xlReport32Use the xlReport3 formatting for the PivotTable.
xlReport43Use the xlReport4 formatting for the PivotTable.
xlReport54Use the xlReport5 formatting for the PivotTable.
xlReport65Use the xlReport6 formatting for the PivotTable.
xlReport76Use the xlReport7 formatting for the PivotTable.
xlReport87Use the xlReport8 formatting for the PivotTable.
xlReport98Use the xlReport9 formatting for the PivotTable.
xlTable110Use the xlTable1 formatting for the PivotTable.
xlTable1019Use the xlTable10 formatting for the PivotTable.
xlTable211Use the xlTable2 formatting for the PivotTable.
xlTable312Use the xlTable3 formatting for the PivotTable.
xlTable413Use the xlTable4 formatting for the PivotTable.
xlTable514Use the xlTable5 formatting for the PivotTable.
xlTable615Use the xlTable6 formatting for the PivotTable.
xlTable716Use the xlTable7 formatting for the PivotTable.
xlTable817Use the xlTable8 formatting for the PivotTable.
xlTable918Use the xlTable9 formatting for the PivotTable.


Show: