PivotTable Properties

Indicated whether diplay all subtotal at top of group, Change will cover every field's setting

Gets/sets the auto format type of PivotTable.

Gets/sets built-in pivot style.

Returns cache used by this pivot table. Read-only.

Gets Index of the pivot Cache.Read-only.

Returns the collection of calculated fields of the specified pivot table.Read-only.

Returns the collection of Column field for the specified pivot table.Read-only.

Specifies the number of columns per page for this PivotTable that the filter area will occupy.

Gets or sets the name of the custom table style for the pivot table.

Gets collection of pivot table data fields. Read-only.

True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.

Gets/sets value controlling whether or not filter buttons and PivotField captions for rows and columns are displayed in the grid.

True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.

True if drilldown is enabled. The default value is True.

True if the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. The default value is True.

True if the PivotTable Wizard is available. The default value is True.

Returns or sets the string displayed in cells that contain errors when the DisplayErrorString property is True.

Specifies the first column of the PivotTable data, relative to the top left cell in the ref value

Specifies the first column of the PivotTable data, relative to the top left cell in the ref value

Specifies the first row of the PivotTable header, relative to the top left cell in the ref value.

Gets/sets value indicating whether the PivotTable contains column with grand totals for rows (same as ColumnGrand in VBA).

Gets/sets whether compatible with excel2003. The default value is true.

Gets/sets value indicating whether the PivotTable contains row with grand totals for columns (same as RowGrand in VBA).

Returns pivot table location.

True if the PivotTable report is recalculated only at the user's request. The default value is False.

True if the specified PivotTable report outer-row item, column item, subtotal, and grand total labels use merged cells.

Gets pivot table name. Read-only.

Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is True.

Represents the pivot table options.Read-only

Returns or sets the order in which page fields are added to the PivotTable report layout.

Returns the collection of page field for the specified pivot table,Read-only.

Returns or sets the style used in the bound page field area. The default value is a null string (no style is applied by default).

Returns or sets the number of page fields in each column or row in the PivotTable report.

Gets the parent XlsPivotTablesCollection of the current instance.

Returns collection of pivot conditional format. Read-only.

Gets collection of pivot fields. Read-only.

Get quantity of instance references.

True if row, column, and item labels appear on the first row of each page when the specified PivotTable report is printed. False if labels are printed only on the first page. The default value is True.

Gets or sets report filter collection

Returns the collection of Row field for the specified pivot table.Read-only.

Specifies the number of rows per page for this PivotTable that the filter area will occupy.Read-only.

Specifies a boolean value that indicates whether to show column headers for the table.

Specifies a boolean value that indicates whether to show column stripe formatting for the table.

Gets/sets value indicating whether the PivotTable contains grand totals for columns.

Represents the pivot table to add the Calculated Data field in rows

The ShowDrillIndicators property is used for toggling the display of drill indicators in the PivotTable.

Specifies a boolean value that indicates whether to show the last column.

Gets/sets value indicating whether the PivotTable contains grand totals for rows.

Specifies a boolean value that indicates whether to show row headers for the table.

Specifies a boolean value that indicates whether to show row stripe formatting for the table.

Gets or sets a value indicating whether subtotals are shown for all fields in the pivot table.

Gets parent workbook. Read-only.

Gets the worksheet associated with the current instance.