Version Information
Version Added: Excel

Remarks

PivotLines contain only visible items, so collapsed children of items and items in hidden levels are not present in the PivotLine collection.

PivotLines always have a PivotItem in all positions. This means that the PivotLines representing subtotals in the PivotTable contain fewer PivotItems than regular PivotLines.

See also: