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.