Page 280 - Excel Workbook for Dummies

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

4. Make sure that the Chapter 20 folder in the My Practice Spreadsheets folder is
open in the Save In list box in the Save As dialog box.
5. Accept the default filename Exercise20-1.htm and then make sure that the Entire
Workbook option button is selected before you select the Save button to create
the Web file.
6. Open the Chapter 20 folder on your hard disk in Windows Explorer.
Click the Start button on the Windows taskbar, select My Documents, and then
double-click the My Practice Spreadsheets Folder icon followed by the Chapter
20 folder icon.
Notice that in addition to adding an Exercise20-1.htm file icon, converting the
Exercise20-1.xls file to HTML has caused Excel to create an Exercise20-1_files
folder. This folder contains the all files needed to add the paging tabs to the Web
page when viewed with Internet Explorer.
7. Double-click the Exercise20-1.htm file icon to open it with your Web browser.
If you’re viewing the Web page with Internet Explorer, use the page tabs to view
the data in the 2007 first quarter sales data as well as the bar chart. Note, how-
ever, that if you’re using Internet Explorer 6.0 to view this Web page, the security
settings render the tab navigation buttons inoperable.

8. Close the Web browser and Chapter 20 windows to return to the Excel worksheet
and then expand the outline in the spreadsheet table to show all the data on the
2006 Sales worksheet by clicking the three buttons to the left and above the row
and column headers.
9. Preview the expanded version of 2006 Sales worksheet as a Web page, and then
close the Web browser window and open the Save As dialog box for saving work-
sheets as Web pages (File➪Save as Web Page).
10. Select the Selection: Sheet option button and then rename the Page.htm sug-
gested filename to CG Sales 2006.htm before you select the Save button.
11. Open the new CG Sales 2006.htm file in your Web browser and then close all open
windows to return to Excel, where you close the Exercise20-1.xls workbook file
without saving any changes.

Creating interactive Web pages

If you know the users of the spreadsheets you convert to Web pages are going to be
viewing them with Internet Explorer (Version 4.0 or later), you can make it possible for
them to modify the worksheet data on the Web pages by selecting the Add Interactivity
check box in the Save As dialog box when you first save them as Web pages.

Note, however, that before users of one of these later versions of the Internet Explorer
can take advantage of the spreadsheet Web page interactivity in Internet Explorer, they
must also have installed the Microsoft Office Web Components on their computer. These
utilities are not automatically installed when you do a standard installation of Office XP,
so you may have to take time out and install them using the Add or Remove Programs
Control panel (the Office XP Web Components are part of Office Shared Features group
in the Features to Install list box in the Microsoft Office XP Setup dialog box).

Figure 20-2 shows you how a typical interactive data table appears on a new Web
page after opening it with Internet Explorer 6.0. Notice that the interactive table is
self-contained, with a toolbar at the top and a facsimile of the worksheet row and
column header at the top, and vertical and horizontal scroll bars on the right and at
the bottom. Notice also that this table uses gridlines to demarcate the cells and
sports a sheet tab at the bottom like a regular Excel workbook window.