Introduction to the Office PivotTable List

While multiple options exist for creating a PivotTable List, one of which involves starting by creating a PivotTable Report in Excel (complete with data source setup), and then transforming it into a PivotTable List, we will focus upon the design and creation of a PivotTable List "from scratch" in this lesson. We will use FrontPage 2002 as the application from which we can not only to read the PivotTable List (just as a browser would), but from which we can also design and/or edit the PivotTable List and apply our changes for immediate effect. Microsoft FrontPage 2002, which is included in the Premium Edition of Office XP, (and is sold separately, and is available in other ways), is well suited to the purpose of creating PivotTable Lists due to its integration with Office XP.

Designing in FrontPage 2002

Let's start FrontPage 2002, and set about the PivotTable List design process.

1.      Click the Start button.

2.      Select Programs -` FrontPage 2002.

FrontPage 2002 opens, and a new, blank page appears. (If not, simply click the "New" button to create a new page).

3.      Choose Insert from the top menu.

4.      Select Web Component, as shown in Illustration 1.

Illustration 1: Select Web Component

The Insert Web Component selection dialog appears.

5.      Under Component Type (left pane of the dialog), click Spreadsheets and Charts.

6.      From the Choose a Control options that appear in the right pane, select Office PivotTable as shown in Illustration 2 below.

Illustration 2: Selecting the Office Pivot Table Control

7.      Click Finish to enact our selections.

The empty Office PivotTable List appears in the new page, as shown in Illustration 3.

Illustration 3: The Empty PivotTable List