Microsoft Office Tutorials and References
In Depth Information
original workbook. Whenever someone updates the workbook, Excel updates the Web
files to reflect the new content.
To publish a workbook to the Web, click the File tab, click Save As and then, in the Save
As Type list, click Web Page. When you do, Excel displays the Publish button; clicking the
Publish button displays the Publish As Web Page dialog box.
You can use the options in the Publish As Web Page dialog box to select which elements
of your workbook you want to publish to the Web. Clicking the Choose arrow displays a
list of publishable items, including the option to publish the entire workbook, items on
specific sheets, or a range of cells. To have Excel 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 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 publishes a static image of the PivotTable’s current configuration.
In this exercise, you’ll save a workbook as a Web page and then publish a worksheet’s
PivotTable to the Web.
SET UP You need the ShipmentSummary_start workbook located in your Chapter14
practice file folder to complete this exercise. Open the ShipmentSummary_start
workbook, and save it as ShipmentSummary . Then follow the steps.
1. Click the File tab, and then click Save As .
The Save As dialog box opens.