| Name | Description | |
|---|---|---|
 | createPivotTable | Overloaded. Creates a PivotTable report based on a PivotCache object. |
| getIndex | Returns the index number of the object within the collection of similar objects. |
| getRecordCount | Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. |
| getRefreshDate | Returns the date on which the PivotTable cache was last refreshed. |
| getRefreshLocalDateTime | Returns the date on which the PivotTable cache was last refreshed. |
| getRefreshName | Returns the name of the person who last refreshed the PivotTable cache. |
| getRefreshOnFileOpen | Gets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened. Default value is false. |
| getSourceData | Gets the data source for the PivotTable report. |
| refresh | Updates the cache of the PivotTable object. |
| setRefreshOnFileOpen | Sets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened. |
| setSourceData | Sets the data source for the PivotTable report. |