PivotTable.ChangePivotCache Method
Changes the PivotCache of the specified PivotTable.
Version Information
Version Added: Excel
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.