Microsoft Office Web Components

Publish Excel Data to a Spreadsheet Component

1. With the Excel worksheet open, click Save As on the File menu.

2. In the Save As Type list, select Web Page.

3. Click the Entire Workbook option to save the entire workbook as a Web page, or click Selection to save a worksheet as a Web page. (If you want to save only a group of cells, select the cells before clicking Save As in step 1.)

4. Select the Add Interactivity option to make the data available for editing in the Spreadsheet Component on the Web page. Click the Publish button and then select AutoRepublish Every Time This Workbook Is Saved if you want changes made to the data in the original workbook to be published to the Web page.

Sort Data in a Spreadsheet Component

1. On the Spreadsheet Component’s toolbar, click the arrow next to the Sort Ascending or Sort Descending button.

2. Select the field by which you want to sort the data.

   Repeat these steps to sort by other fields.

Sort Data in a PivotTable Component

1. In the PivotTable Component, click the field name by which you want to sort.

2. On the PivotTable Component’s toolbar, click the Sort Ascending or Sort Descending button.

Sort Data in a Chart Component

1. Select the detail items by which you want to sort.

2. On the Chart Component’s toolbar, click the Sort Ascending or Sort Descending button.

Filter Data Displayed in a Spreadsheet Component

1. On the Spreadsheet Component’s toolbar, click the AutoFilter button.

2. Click the arrow next to the field you want to use in your filter.

3. Select or clear the check boxes to display records matching the specified values.

4. Click OK.

Filter Data Displayed in a PivotTable Component

1. Click the arrow next to the field name by which you want to filter.

2. Select or clear the check boxes to display records matching the specified values.

3. Click OK.

Filter Data Displayed in a Chart Component

1. In the Chart Component, click the arrow next to the field name by which you want to filter.

2. Select or clear the check boxes to display or hide matching items.

3. Click OK.

Show the Top or Bottom Items in a PivotTable Component or Chart
Component

1. In the PivotTable Component or Chart Component, click the field or detail item for which you want to show top or bottom items.

2. On the component’s toolbar, click the Show Top/Bottom Items button.

3. Point to the Show Only The Top or Show Only The Bottom.

4. Click the number of items you want to show.

   Note

   This procedure cannot be performed with Office 2000 Web Components.

Insert a Summary Function into a PivotTable Component or Chart
Component

1. In the PivotTable Component or Chart Component, click the field whose values you want to summarize.

2. On the Web component’s toolbar, click the AutoCalc button.

3. Click the summary function (Sum, Count, Min, Max, and so on).

Insert a Subtotal into a PivotTable Component

1. In the PivotTable Component, click the field whose values you want to subtotal.

2. On the PivotTable Component’s toolbar, click the Subtotal button.

Insert Calculated Totals and Detail Fields into a PivotTable Component

1. On the PivotTable Component’s toolbar, click the Calculated Totals And Fields button and then click Create Calculated Total or Create Calculated Detail Field.

2. Enter a name and formula for the calculated total or calculated field.

3. Drag the calculated total or field from the PivotTable field list to the PivotTable Component.

   Note

   This procedure cannot be performed with Office 2000 Web Components.