HOW TO: Save a Workbook as a Web Page in Excel 2002

This step-by-step article explains how to save your Microsoft Excel workbook as one of the following types of Web pages:

• As a static HTML Web page to be viewed in a Web browser.
• As an interactive Web page. You can save the worksheet as an interactive Microsoft Office Web Component: a dynamic object that enables users to download their own copies of the workbook and then make their own changes in it, independent of anyone else. New features of the Office Spreadsheet Web Component introduced with Microsoft Excel 2002 enable you to save the entire workbook interactively. In earlier versions of Excel, only individual worksheets can be saved in this way.

Save Workbook as Web Page

To save your workbook as an interactive Office Web Component, follow these steps.

NOTE: To save the workbook as a static HTML Web page, omit step 6.

1. Start Excel, and then open the workbook that you want to save as a Web page.
2. On the File menu, click Save as Web Page.
   
   Note that the entire workbook is saved by default.
3. Click Publish.
4. In the Publish as Web Page dialog box, click the Choose arrow, and then select Entire workbook.
5. To save the workbook as a static HTML Web page, leave the Add interactivity with check box cleared (unselected), and then proceed directly to step 7.
6. To save your workbook as an Office Web Component, click to select the Add interactivity with check box. By default, Spreadsheet functionality is selected. The other option, Pivot Table functionality, allows you to create Pivot Tables directly from the Web page.
7. In the File Name box, type the path and file name.
8. If you would like the workbook to be automatically republished whenever the source workbook is saved, click to select the AutoRepublish every time this workbook is saved check box.
9. Click to select the Open published Web page in browser check box, and then click Publish.

Note that the Web page that you just created opens in your default browser with Sheet1 displayed initially. To access other worksheets, click the arrow on the sheet tab, and then select the worksheet that you want.

For additional information about how to use the AutoRepublish feature, click the article number below to view the article in the Microsoft Knowledge Base: