A PivotTable object represents a pivot table in a worksheet and allows the pivot table to be managed.

 public sealed class PivotTable
Public NotInheritable Class PivotTable

To create a PivotTable object, call PivotTables.CreatePivotTable(Area, Int32, Int32).

Name

Description

[ChangeDataSource(Area)

PivotTable.ChangeDataSource(Area)

ColumnLabels

DataFields

Name

PageFields

PivotTableSettings

RowLabels

SourceFields