Edit

Share via


PivotTable.ChangePivotCache(Object) Method

Definition

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.

Applies to