XlsPivotCache Properties

Gets the calculated index of the item. This property always returns 1.

Specifies the version of the application that created the cache. This attribute is application-dependent.

Specifies a boolean value that indicates whether the user can refresh the cache.

Indicates whether the pivot cache has named range

Gets zero-based cache index.Read-only.

Specifies a boolean value that indicates whether the application should query and retrieve records asynchronously from the cache.

Specifies a boolean value that indicates whether the cache needs to be refreshed.

Specifies a boolean value that indicates whether the application will apply optimizations to the cache to reduce memory usage

Specifies a boolean value that indicates whether the application will refresh the cache

Specifies a boolean value that indicates whether the pivot records are saved with the cache.

Specifies whether the cache's data source supports subqueries

Specifies a boolean value that indicates whether the cache is scheduled for version upgrade.

Specifies the earliest version of the application that is required to refresh the cache.

Indicates whether data array is required by this record.

Gets parent object.

Contains the name of the pivot cache NamedRange

Get quantity of instance references.

Gets/sets refresh date of the cache.

Gets or sets the name or identifier of the user or process that last refreshed the data.

Specifies the version of the application that last refreshed the cache. This attribute depends on whether the application exposes mechanisms via the user interface whereby the end-user can refresh the cache.

Returns the data source for the PivotTable report. Read-only.

Data source is one of: 1 - Excel worksheet, 2 - external data, 4 - consolidation, 8 - scenario PivotTable. Specifies the pivot table cache source type.Read-only.

Specifies whether the cache's data source supports attribute drilldown.