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.

Name	Description
Refresh()	Refreshes the PivotTable cache to get the latest data from the data source.