| Microsoft Office 2000/Visual Basic Programmer's Guide | |
The PivotTable List control lets users analyze data displayed on a Web page in Internet Explorer 5. This control combines the list features of Excel (sort, AutoFilter, and outline) with the auto-summarizing features of PivotTable reports into a single 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 easily transform their view of data 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. Once 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 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 allows users to merge the ability to create and report on data in an Access database with the ability to analyze data in Excel.