This documentation is archived and is not being maintained.

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.




Show: