Export (0) Print
Expand All

PivotTable Interface 

Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Public Class ivotTableImplementation
	Implements PivotTable
End Class
Dim ivotTableImplementation1 As New ivotTableImplementation()

public interface PivotTable
public interface PivotTable
public interface PivotTable

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 then click Record New Macro.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft