PivotTable.ChangePivotCache(Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Changes the PivotCache of the specified PivotTable.
public:
void ChangePivotCache(System::Object ^ PivotCache);public void ChangePivotCache (object PivotCache);Public Sub ChangePivotCache (PivotCache As Object)Parameters
- PivotCache
- Object
Required String a PivotTable or PivotCache object that represents the new PivotCache for the specified PivotTable.
Remarks
The ChangePivotCache(Object) 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(Object) method is used with a PivotTable that is connected to an external data source.