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.