Saving Workbooks for the Web


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:

<B>Excel</B>


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.

Note

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.

Important

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.


1.

Click the Microsoft Office Button and then click Save As.

The Save As dialog box appears.

2.

In the File name box, type Shipment Summary Web.

3.

Click the Save as type down arrow and then click Web Page.

The Save As dialog box changes to reflect the Web Page file type.

4.

Click Save.

A warning dialog box appears, indicating that the workbook might contain elements that can't be saved in a Web page.

5.

Click Yes to save the workbook as a Web file.

The dialog box disappears, and Excel 2007 saves the workbook as a Web page.

6.

Click the Microsoft Office Button and then click Close.

The Shipment Summary Web file disappears.

7.

Click the Microsoft Office Button, and then, in the list of recently viewed files, click Shipment Summary.

The Shipment Summary workbook appears.

8.

Click the Microsoft Office Button and then click Save As.

The Save As dialog box appears.

9.

In the File name box, type Shipment Summary Publish.

10.

Click the Save as type down arrow and then click Web Page.

The Save As dialog box changes to reflect the Web Page file type.

11.

Click Publish.

The Publish as Web Page dialog box appears.

12.

Click the Choose box's down arrow and then click Items on Sheet 2.

The available items on Sheet2 appear.

13.

In the Item to Publish list, click PivotTable.

14.

Select the AutoRepublish every time this workbook is saved check box.

15.

Click Publish.

Excel 2007 publishes the PivotTable to a Web page. Excel 2007 will update the contents of the Web page whenever a user saves the Shipment Summary workbook.

CLOSE the Shipment Summary workbook.

CLOSE Excel 2007.





MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net