Page 118 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 104

EXCEL DATA ANALYSIS

SAVE FOR WEB

ou can make your data analysis results available to any blank worksheets from your workbook before saving
other viewers by saving your worksheets and them as Web pages.
Y workbooks to the Web so that colleagues can view When you save in the HTML file format, you can create either
them on the Internet. When you save your data, you need a static or interactive version of your workbook. With static
to create an HTML page. HTML, or HyperText Markup pages, users can only view the content of the workbook. You
Language, is a standard format you can use to create Web should select this option when you want to share analysis
pages and that all Web browsers can interpret. When you data, but you do not want other users to alter it.
select that file format, Excel saves your workbook selection
as an HTML page. With an interactive HTML version of the workbook, you
provide each viewer the option of altering the page's
When you save your workbook as a Web page, you can contents. The Web page displays a toolbar specifically for
save either the current worksheet or the entire workbook. the purpose of modifying data. If you save a PivotTable or
Keep in mind, if you decide to save the entire workbook, PivotChart as an interactive HTML page, the user can apply
Excel saves each worksheet as a separate HTML page. If one filtering to the areas to retrieve the desired results. See
of the worksheets in your workbook is blank, Excel creates Chapter 7 for more information on PivotTables. See Chapter
a blank worksheet. Therefore, you may consider removing
8 for more information on PivotCharts.

SAVE FOR WEB

Ch05-SaveWebPage-interactive.htm

CREATE HTML FILE ■ The Save As dialog box ¤ Select the Web Page ■ You can click Add
displays. (*.htm; *.html) option in the interactivity make the
⁄ Click File ➪ Save As.
Save as type field. HTML page interactive.
■ The Save radio buttons › Click Save.
display.
‹ Select whether you want
to save the entire workbook,
or just the selected worksheet.
104