Share via

Creating a PivotTable List Control

  • 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.

You can insert a PivotTable List control in a Web page in several ways:

  • In Microsoft® Excel, you add a PivotTable List control to a Web page by creating a list or PivotTable report in Excel and then using the Publish as Web Page dialog box to save the data in a PivotTable List control on a Web page.
  • In Microsoft® Access, you can add a PivotTable List control to a data access page by dragging a table or query from the field list to the page, or by using the PivotTable control on the toolbox. This creates a PivotTable List control populated with data from the table or query in the open database.
  • In Microsoft® FrontPage®, you can add an unbound PivotTable List control to a page by pointing to Component on the Insert menu, and then clicking Office PivotTable. To bind the control to data, you use Microsoft® Visual Basic® Scripting Edition (VBScript) code in the Web page.
  • In a Web page, you can insert a PivotTable List control by adding an <OBJECT> tag for the control to the page and specifying the control's CLSID as the setting for the CLASSID attribute. Then, you can use Visual Basic for Applications (VBA) or VBScript code to fill the control programmatically when the page loads.

The CLSID for the PivotTable List control and all the objects and related methods and properties for the control are documented in the owcvba10.chm Help file, which is located in the c:\program files\common files\microsoft shared\web components\10\<langid>.

Note   The path to the owcvba10.chm Help file reflects the language ID folder (1033) for U.S. English language support in Office. The language ID folder c:\program files\common files\microsoft shared\web components\10\<langid> differs for each language.

See Also

Using Web Technologies with Office XP | Understanding the Chart Control | Understanding the PivotTable List Control | Understanding the Data Source Control