Page 284 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 267
Chapter 20: Publishing Spreadsheets as Web Pages 267

2. Make sure that Items on Employee Data List is selected in the Choose text box,
that Sheet with All Contents of Employee Data List is highlighted in the list box
below, and that the Add Interactivity check box and Spreadsheet Functionality in
the drop-down list box to its right are selected.
3. Select the Browse button to open the Publish As dialog box with the Chapter 20
folder selected and then replace Page.htm with Exercise 20-3.htm (be sure that
you retain the .htm filename extension) before you select OK.
4. In the Publish as Web Page dialog box, select the Open Published Web Page in
Browser check box and then select its Publish button.

After saving the data list in the Exercise20-3.htm Web page, Internet Explorer
opens the data list complete with a toolbar in the new HTML document.
5. Click the AutoFilter button on the data list’s toolbar to add AutoFilter drop-down
buttons to each of the fields in the data list.
6. Filter the data list so that only the records of the female employees are displayed
in the interactive worksheet.
Click the (Show All) check box in the Gender field’s drop-down list to deselect all
the check boxes and then click the F check box before selecting OK.
7. Sort the data list alphabetically by department name.
Click the cell with the Dept field name (E1) and then click the Sort Ascending
button on the data list toolbar.
8. Use the horizontal scroll bar to display the Profit Sharing field and then filter the
list so that only the female employees who participate in the profit-sharing plan
are displayed in the data list.
9. Remove the row and column headings, gridlines, sheet tab, and toolbar from the
data list and then, if you have a printer available, print the filtered and sorted
data.
Deselect the appropriate check boxes on the Sheet and Workbook tabs of the
Commands and Options dialog box to remove the row and column headings,
gridlines, sheet tab, and toolbar from the interactive data list.
10. Close Internet Explorer and then the Exercise20-3.xls workbook in Excel without
saving your changes.

Web pages with interactive pivot tables

When you create interactive Web pages with pivot tables, your users can pivot the
fields in a table, add new fields to the table, refresh the table data from the external
data source (assuming that this source is accessible from the Web page), show details
for any of the summarized data in the table, add calculated fields to the table, and
page through the summaries using different items in the page fields (see Chapter 19).

Try It

Exercise 20-4: Creating a Web Page with an Interactive Pivot Table
Open the workbook Exercise20-4.xls in your Chapter 20 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains a pivot table generated from a copy of the
Employee data list that you can use to practice creating a Web page with an interactive
pivot table: