XlPivotLineType Enumeration

  • Article

Specifies the type of the PivotLine.

Version Information

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.