Office Web Components: PivotTable lists

Applies to
Microsoft Office XP

Microsoft Office Web Components are a collection of Component Object Model (COM) controls. However, if you previously chose not to install it, you can download Office XP Tool: Web Components from Downloads on Microsoft Office Online.

A PivotTable® list is an interactive table that you can use to analyze data dynamically within your Web browser. You can use a PivotTable list to view and organize data from lists or databases, to look for information or details, and to create personalized summaries and reports.

Play Demo

A PivotTable list can analyze data from a Microsoft Excel worksheet range, a relational database such as Microsoft Access or Microsoft SQL Server™, or any online analytical processing (OLAP) data source that supports OLEDB for OLAP, such as Microsoft OLAP Services for SQL Server. As you insert a PivotTable list component, you can specify a data source with the connection editor, which is available directly from the PivotTable list control in your design program.

 Note   The connection editor creates the "plumbing" that your Web page needs to display data from the database so that you don't have to write a program or script to make the connection. Once the connection editor has created the connection, all that you and the users of your Web page need to know to access the data is the login and password for the database, if required for database access.

You can save data to a Web page from Excel and choose to make a Web page interactive. When you publish either a PivotTable report or an external data range returned through Microsoft Query as an interactive Web page, you can choose to publish the data as a PivotTable list. You can also insert PivotTable list components into Web pages you create in the data access page Design view in Microsoft Access and in Microsoft FrontPage®.