Opening new Web page at the time you save it
If you want, you can open your new Web page in your computer's Web browser immediately after saving it. To do this, click the Publish button in the Save As dialog box after specifying what part of the workbook to save. When you click this button, Excel opens the Publish as Web Page dialog box.
You then need to follow these steps:
- In the Item to Publish drop-down list box, select what part of the workbook you want to save in the HTML file.
By default, Excel selects Items on Sheet1 (or whatever your first worksheet is named). To save all the worksheets in the workbook, select Entire Workbook on this drop-down list. To save only the range of cells you've selected, select Range of Cells.
- To make the Web page interactive, select the Add Interactivity With check box and then select the type of interactivity (Spreadsheet,
Chart, or PivotTable) in the drop-down list box to its right.
See the section "Creating Interactive Web Pages," later in this tutorial, for details on the various types of Web interactivity that Excel supports.
- To add a page title or to edit the one you added in the Save As dialog box, click the Change button, make the changes in the Set Title dialog box, and then click OK.
- To select a new folder and assign a new filename (other than Page.htm, which Excel assigns by default), edit the pathname in the File Name text box; or, click the Browse button select the appropriate folder, enter the desired filename, and click OK.
- Select the AutoRepublish Every Time This Worksheet Is Saved check box if you want Excel to automatically save all changes you make in the Excel worksheet or workbook in the HTML file that you create with its data.
- Clear the Open Published Web Page in Browser check box only if you don't want to open the HTML file that you're creating in your Web browser as soon as you click the Publish button.
- Click the Publish button to close the Publish as Web Page dialog box.
If you kept the Open Published Web Page in Browser check box selected, Windows then launches your computer's Web browser and opens the newly saved HTML version of the worksheet or workbook in this program. When you finish reviewing the Web page, close your browser to return to Excel with your original worksheet.