This documentation is archived and is not being maintained.

XlPivotFormatType Enumeration

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

Version Added: Excel 2007

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.

Show: