Excel 2007 enables you to save Excel 2007 workbooks as Web documents, so you and your colleagues can view workbooks over the Internet or a corporate intranet. For a document to be viewed on the Web, the document must be saved as a Hypertext Markup Language (HTML) file. HTML files, which end with either the .htm or the .html extension, include tags that tell a Web browser such as Microsoft Internet Explorer® how to display the contents of the file.
For example, you might want to set the data labels in a workbook apart from the rest of the data by having the labels displayed with bold text. The coding in an HTML file that indicates text to be displayed as bold text is <B>...</B>, where the ellipsis points between the tags are replaced by the text to be displayed. So the following HTML fragment would be displayed as Excel:
You can create HTML files in Excel 2007 by clicking the Microsoft Office Button and clicking Save As to display the Save As dialog box. To save a workbook as an HTML file, select the Entire Workbook option button, type a name for the file in the File name box, click the Save as Type down arrow, and click Web Page (*.htm; *.html). With the file type set to Web Page, you can then click Save to have Excel 2007 create an HTML document for each sheet in the workbook.
If your workbook contains data only on the sheet displayed when you save the workbook as a Web page, only that worksheet is saved as a Web page.
After you save an Excel 2007 workbook as a series of HTML documents, you can open it in your Web browser. To open the Excel 2007 file, start Internet Explorer, open the File menu, and then click Open to display the Open dialog box. In the Open dialog box, click the Browse button to open the Microsoft Internet Explorer dialog box. You can use the controls in that dialog box to identify the file you want to open.
When you double-click the file to open, the Microsoft Internet Explorer dialog box disappears and the file's name and path appear in the Open box. To display the Excel 2007 workbook, click OK, and the workbook appears in Internet Explorer. You can move among the workbook's worksheets by clicking the sheet tabs at the lower-left corner of the page.
Saving a workbook to an organization's intranet enables you to share data with your colleagues. For example, Consolidated Messenger's chief operating officer, Jenny Lysaker, could save a daily report on package misdeliveries to her team's intranet so that everyone could examine what happened, where the problem occurred, and how to fix the problem. It's also possible to save a workbook as a Web file that retains a link to the original workbook. Whenever someone updates the workbook, Excel 2007 updates the Web files to reflect the new content.
To publish a workbook to the Web, click the Microsoft Office Button, click Save As, click the Save as Type down arrow, and click Web Page (*.htm; *.html). When you do, Excel 2007 displays the Publish button; clicking the Publish button displays the Publish as Web Page dialog box.
The controls in the Publish as Web Page dialog box enable you to select which elements of your workbook you want to publish to the Web. Clicking the Choose down arrow displays a list of publishable items, including the option to publish the entire workbook, items on specific sheets, a PivotTable® dynamic view, or a range of cells. To have Excel 2007 update the Web page whenever someone updates the source workbook, select the AutoRepublish Every Time This Workbook Is Saved check box. You can also specify which text appears on the Web page's title bar. To do so, click the Change button, type the page title in the Set Title dialog box, and click OK. When you save a workbook that has AutoRepublish turned on, Excel 2007 displays a dialog box indicating that the changes will update the associated Web file.
When you save a PivotTable to the Web, the PivotTable doesn't retain its interactivity. Instead, Excel 2007 publishes a static image of the PivotTable's current configuration.
In this exercise, you save a workbook as a Web page and then publish a worksheet's PivotTable to the Web.
USE the Shipment Summary workbook in the practice file folder for this topic. This practice file is located in the My Documents\Microsoft Press\Excel SBS\Web folder.
OPEN the Shipment Summary workbook.
CLOSE the Shipment Summary workbook.
CLOSE Excel 2007.