PivotCache Members
Represents the data cache for a PivotTable report.Properties
| Name | Description |
|---|---|
| CacheType | Gets the type of the PivotCache source. |
| RefreshDate | Returns the date when the PivotTable cache was last refreshed. |
| RefreshedBy | Returns the name of the user who last refreshed the PivotTable cache. |
| RefreshOnLoad | Specifies whether to refresh the PivotTable cache when the document is opened. |
| SaveData | Specifies whether to save the cached source data with a workbook. |
| SourceRange | Gets the source cell range whose data are stored in the PivotCache. |
Methods
| Name | Description |
|---|---|
| Refresh() | Refreshes the PivotTable cache to get the latest data from the data source. |
See Also