| Name | Description | |
|---|---|---|
 | ColumnGrand | Gets whether the PivotTable report shows grand totals for columns (read or write). |
| ColumnRange | Returns a Range object that represents the range that contains the column area in the PivotTable report (read-only). |
| DataBodyRange | Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row (read-only). |
| DisplayContextTooltips | Gets or sets whether tooltips are displayed for PivotTable cells (read or write). |
| DisplayMemberPropertyTooltips | Gets or sets whether to display member properties in tooltips. |
| GrandTotalName | Gets or sets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total". |
| Name | Gets or sets the name of the object. |
| PivotCache | Returns a PivotCache object that represents the cache for the specified PivotTable report. |
| PivotFields | Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report. |
| RowGrand | Gets whether the PivotTable report shows grand totals for rows. |
| RowRange | Returns a Range object that represents the range including the row area on the PivotTable report. |
| TableRange1 | Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields. |
| TableStyle | Gets or sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default). |
| Tag | Gets or sets a string saved with the PivotTable report. |
The following tables list the members exposed by IPivotTable.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | ClearAllFilters | Deletes all filters currently applied to the PivotTable. This includes deleting all filters in the PivotFilters collection of the PivotTable object, removing any manual filtering applied, and setting all PivotFields in the Report Filter area to the default item. |
| ClearTable | Clears a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it. |
| Refresh | Refreshes the PivotTable report from the source data. Returns True if it’s successful. |
| SubtotalLocation | Changes the subtotal location for all existing PivotFields. Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well. |
| Update | Updates the link or PivotTable report. |
See Also