PivotTable.ChangePivotCache(Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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.

Applies to