This documentation is archived and is not being maintained.

PivotTable Methods 

  Name Description
AddDataField Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.
AddFields Adds row, column, and page fields to a PivotTable report or PivotChart report.
CalculatedFields Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable report. Read-only.
CreateCubeFile Creates a cube file from a PivotTable report connected to an Online Analytical Processing (OLAP) data source.
Format Sets a PivotTable report to one of the predefined indented, nonindented, or cross-tabulated formats.
GetData Returns data from the specified PivotTable cell.
GetPivotData Returns a Range object with information about a data item in a PivotTable report.
ListFormulas Creates a list of calculated PivotTable items and fields on a separate worksheet.
PivotCache Returns a PivotCache object that represents the cache for the specified PivotTable report. Read-only.
PivotFields Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report. Read-only.
PivotSelect Selects part of a PivotTable report.
PivotTableWizard Creates a PivotTable object. This method doesn’t display the PivotTable Wizard. This method isn’t available for OLE DB data sources. Use the Add method to add a PivotTable cache, and then create a PivotTable report based on the cache.
RefreshTable Refreshes the PivotTable report from the source data. Returns True if it’s successful.
ShowPages Creates a new PivotTable report for each item in the page field. Each new report is created on a new worksheet.
Update Updates the link or PivotTable report.