Understanding the PivotTable List Control

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.

The PivotTable List control makes it possible for users analyze data displayed on a Web page in Microsoft® Internet Explorer 5 or later. This control combines the list features of Microsoft® Excel (sort, AutoFilter, and outline) with the auto-summarizing features of PivotTable reports into a single Microsoft® ActiveX® control that runs in Internet Explorer. Therefore, a PivotTable list on a Web page is roughly equivalent to a PivotTable report in an Excel worksheet.

With the PivotTable List control, users can transform their view of data easily by using the mouse or simple keyboard commands. Although the author of the data determines the initial view of the data when the page is first viewed in Internet Explorer, users are free to use the dynamic run-time features of the PivotTable List control to manipulate and analyze the data in any way they choose. When users have customized the data in a PivotTable List control, they can save that view of the data and share it with others.

A PivotTable list is the best way for Microsoft® Office users to get dynamic reporting and data analysis by using Internet Explorer. Using the PivotTable List control to work with data on a Web page makes it possible for users to merge the ability to create and report on data in an Access database with the ability to analyze data in Excel.

See Also

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