Share via


PivotTables Interface

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)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020873-0000-0000-C000-000000000046")> _
Public Interface PivotTables _
    Inherits IEnumerable
'Usage
Dim instance As PivotTables
[InterfaceTypeAttribute()]
[GuidAttribute("00020873-0000-0000-C000-000000000046")]
public interface PivotTables : IEnumerable

Remarks

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.

See Also

Reference

PivotTables Members

Microsoft.Office.Interop.Excel Namespace