Item Method (PivotCaches Collection)

Applies To

PivotCaches collection object.

Description

Returns a single PivotCache object from a PivotCaches collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a PivotCaches object.

Index Required Variant. The index number of the pivot cache.

Example

This example refreshes cache one.

ActiveWorkbook.PivotCaches.Item(1).Refresh