PivotTable Properties

Represents a PivotTable report on a worksheet.

Name	Description
BandedColumns	Gets or sets a value indicating whether alternate shading should be applied to the pivot table columns.
BandedRows	Gets or sets a value indicating whether alternate shading should be applied to the pivot table rows.
Behavior	Provides access to an object that allows you to apply restrictions on different PivotTable operations.
Cache	Returns the data cache for the specified PivotTable report.
CalculatedFields	Provides access to the collection of calculated fields in the specified PivotTable report.
ColumnFields	Provides access to the collection of fields located in the column axis area of the PivotTable report.
DataFields	Provides access to the collection of fields located in the data area of the PivotTable report.
Fields	Provides access to the collection of all fields in the PivotTable report.
Filters	Provides access to the collection of filters applied to the current pivot table.
Layout	Provides access to options used to adjust the PivotTable report layout.
Location	Provides access to an object that contains information about the location of a pivot table and its regions.
Name	Gets or sets the PivotTable name.
PageFields	Provides access to the collection of fields located in the PivotTable’s report filter area.
RowFields	Provides access to the collection of fields located in the row axis area of the PivotTable report.
ShowColumnHeaders	Gets or sets a value indicating whether to apply the style formatting to column headers.
ShowRowHeaders	Gets or sets a value indicating whether to apply the style formatting to row headers.
Style	Gets or sets the style applied to the pivot table.
View	Provides access to the display settings of a PivotTable report.