This documentation is archived and is not being maintained.

XlPivotLineType Enumeration

Specifies the type of the PivotLine.

Version Added: Excel 2007

Name

Value

Description

xlPivotLineBlank

3

Blank line after each group.

xlPivotLineGrandTotal

2

Grand Total line.

xlPivotLineRegular

0

Regular PivotLine with pivot items.

xlPivotLineSubtotal

1

Subtotal line.

Show: