Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotTable.ChangePivotCache Method

Office 2007
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

NameRequired/OptionalData TypeDescription
bstrRequiredStringA 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.




Community Additions

Show: