.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

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