Skip to content

Latest commit

 

History

History
42 lines (25 loc) · 1.01 KB

Excel.PivotTable.CacheIndex.md

File metadata and controls

42 lines (25 loc) · 1.01 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.CacheIndex property (Excel)
vbaxl10.chm235102
vbaxl10.chm235102
Excel.PivotTable.CacheIndex
fe1a88b7-dfd0-e031-e739-0b5781de1c0d
05/08/2019
medium

PivotTable.CacheIndex property (Excel)

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

Syntax

expression.CacheIndex

expression A variable that represents a PivotTable object.

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.

Example

This example sets the cache for the PivotTable report named Pivot1 to the cache of the PivotTable report named Pivot2.

Worksheets(1).PivotTables("Pivot1").CacheIndex = _ 
 Worksheets(1).PivotTables("Pivot2").CacheIndex

[!includeSupport and feedback]