PivotTables interface
Office 2013 and later
A collection of all the PivotTable objects on the specified worksheet.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Use the PivotTables method to return the PivotTables collection.
Use the PivotTableWizard method to create a new PivotTable report and add it to the collection.
Use PivotTables(index), where index is the PivotTable index number or name, to return a single PivotTable object.
Because PivotTable report programming can be complex, it’s generally easiest to record PivotTable report actions and then revise the recorded code. To record a macro, point to Macro on the Tools menu and click Record New Macro.
Show: