The Pivot Cache Object

Pivot tables can manipulate the source data in a variety of ways, and this can require a great deal of processing power. For maximum efficiency, the data for a pivot table is first stored in memory in what is referred to as a pivot cache. The pivot table, itself, actually provides various views of the pivot cache. This allows manipulation of the data without the need to access the original source further which might, after all, be an external data source.

The PivotCache object represents a pivot table's cache. It is returned by the PivotCache method of the PivotTable object. Let us take a look at some of the main properties and methods of the PivotCache object.

0 -1

Post a comment