Share via


PivotTable.ChangePivotCache Method (Excel)

Changes the PivotCache of the specified PivotTable.

Version Information

Version Added: Excel 2007

Syntax

expression .ChangePivotCache(bstr)

expression A variable that represents a PivotTable object.

Parameters

Name

Required/Optional

Data Type

Description

bstr

Required

String

A PivotTable or PivotCache object that represents the new PivotCache for the specfied PivotTable.

Remarks

The ChangePivotCache method can only be used with a PivotTable that uses data stored on a worksheet as its data source. A run-time error will occur if the ChangePivotCache method is used with a PivotTable that is connected to an external data source.

See Also

Concepts

PivotTable Object

PivotTable Object Members