Share via


PivotTable.CacheIndex Property

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property CacheIndex As Integer
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As Integer

value = instance.CacheIndex

instance.CacheIndex = value
int CacheIndex { get; set; }

Property Value

Type: System.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.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace