ExcelPivotCacheDefinition Properties

Office Open XML

The ExcelPivotCacheDefinition type exposes the following members.

Properties

  NameDescription
CacheDefinitionUri
The package internal URI to the pivottable cache definition Xml Document.
CacheDefinitionXml
Provides access to the XML data representing the cache definition in the package.
CacheSource
Type of source data
PivotTable
Referece to the PivoTable object
SourceRange
The source data range when the pivottable has a worksheet datasource. The number of columns in the range must be intact if this property is changed. The range must be in the same workbook as the pivottable.

See Also