PivotTable Object

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

PivotTable
Aa190726.space(en-us,office.10).gifAa190726.parchild(en-us,office.10).gif

Represents the container for a PivotTable list.

Using the PivotTable Object

You can use either the CreateObject method or the New keyword to create a PivotTable object.

The object ID for a PivotTable list on an HTML page returns a PivotTable object. The programmatic identifier for the PivotTable object is CLSID:0002E552-0000-0000-C000-000000000046. The following example creates a PivotTable list named "PivotTable1" on an HTML page.

  <object id=PivotTable1 classid=CLSID:0002E552-0000-0000-C000-000000000046></object>