ContextQMD
Back to Devexpress

PivotCache Properties

officefileapi-devexpress-dot-spreadsheet-dot-pivotcache-dot-underscore-properties.md

latest1.3 KB
Original Source

PivotCache Properties

Represents the data cache for a PivotTable report.

NameDescription
CacheTypeGets the type of the PivotCache source.
RefreshDateReturns the date when the PivotTable cache was last refreshed.
RefreshedByReturns the name of the user who last refreshed the PivotTable cache.
RefreshOnLoadSpecifies whether to refresh the PivotTable cache when the document is opened.
SaveDataSpecifies whether to save the cached source data with a workbook.
SourceRangeGets the source cell range whose data are stored in the PivotCache.

See Also

PivotCache Interface

PivotCache Members

DevExpress.Spreadsheet Namespace