Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotCache Members

In This Article
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