This documentation is archived and is not being maintained.

XlPivotLineType Enumeration

Office 2007
Specifies the type of the PivotLine.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlPivotLineBlank3Blank line after each group.
xlPivotLineGrandTotal2Grand Total line.
xlPivotLineRegular0Regular PivotLine with pivot items.
xlPivotLineSubtotal1Subtotal line.


Show: