PivotTable.CacheIndex Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the index number of the PivotTable cache. Read/write Integer.

public:
 property int CacheIndex { int get(); void set(int value); };

public int CacheIndex { get; set; }

Public Property CacheIndex As Integer

Property Value

Int32

Remarks

If you set the CacheIndex property so that one PivotTable report uses the cache for a second PivotTable report, the first report’s fields must be a valid subset of the fields in the second report.

Applies to