Page 286 - Excel Workbook for Dummies

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

2. Make sure that Items on 2006 Production is selected in the Choose text box, that
Chart with Chart1 (Column) is highlighted in the list box below, and that the Add
Interactivity check box and Chart 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-5.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-5.htm Web page, Internet Explorer
opens the Scheduled Production – 2006 Clustered Column chart with the data
table immediately beneath it, complete with toolbar in the new HTML document.
5. Scroll down to display the chart’s supporting data table and then make the fol-
lowing changes to the designated cells, noting the changes to the associated
columns in the chart above as you update each entry:
• 350 in cell C3 with production quota for Part 101 in May 2006
• 380 in cell F3 with production quota for Part 101 in August 2006
• 650 in cell E5 with production quota for Part 103 in July 2006
6. Close Internet Explorer and then the Exercise20-5.xls workbook in Excel without
saving your changes.

Exporting an interactive Web page to Excel

Unfortunately, you can’t save any of the changes that you make to an interactive Web
page in Internet Explorer. The only way that you can save any of the formatting or edit-
ing changes you to make to an interactive data table, data list, or pivot table is to export
the page back to Excel as an .XML (Extensible Markup Language) file and then save the
changes there.

To do this, you click the Export to Microsoft Excel button (the one with the green XL
logo with a pencil) on the toolbar at the top of the interactive table or list. Clicking this
button launches Excel on your computer and opens the interactive table or list with
your edits. (In the case of interactive charts, only the data table attached to the chart
opens in Excel, not the chart itself.)

The .XML file that opens in the Excel window is given a temporary filename, something
like OWCSheet1.XML (OWC stands for Office Web Components), that appears on the
Excel program window’s title bar followed by the (Read Only) to indicate that the file is
open in read-only mode. This means that you must choose the File➪Save As command
to save the Web page’s changes on your disk. In the Save As dialog box, you can save
the file by giving it a new filename in the File Name text box (anything’s better than
OWCSheet followed by a number!) and selecting a new folder (all OWCSheet files are
automatically saved in the Temp folder on your hard disk).

Note that Excel automatically saves the file as an .XML file, the type of HTML that
enables you to interact with it in the Internet Explorer. If you’re not concerned about
saving the interactivity and only want to be able to open the edited data table or list in
Excel, remember to change the Save as Type setting from XML Spreadsheet (*.xml) to
Microsoft Excel Workbook (*.xls).