Skip to main content
Row

PivotCache Properties

Represents the data cache for a PivotTable report.
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.
See Also