PivotCache Methods (Excel)

This object has the following methods:

Name

Description

CreatePivotChart

Creates a standalone PivotChart from a PivotCache Object (Excel) object. A Shape Object (Excel) object is returned.

CreatePivotTable

Creates a PivotTable report based on a PivotCache object. Returns a PivotTable object.

MakeConnection

Establishes a connection for the specified PivotTable cache.

Refresh

Causes the specified chart to be redrawn immediately.

ResetTimer

Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property.

SaveAsODC

Saves the PivotTable cache source as an Microsoft Office Data Connection file.

Show:
© 2014 Microsoft