Microsoft Office Tutorials and References
In Depth Information
Saving workbooks as web content
Display the Backstage view, and then click Close .
In the Backstage view, click Open , click Recent Workbooks , and then, in the list
of recently viewed files, click ShipmentSummary to open the ShipmentSummary
In the Backstage view, click Save As , and then click Browse to open the Save As
In the File name box, enter ShipmentSummaryPublish .
In the Save as type list, click Web Page . The Save As dialog box changes to reflect
the Web Page file type.
Click Publish to open the Publish as Web Page dialog box.
In the Choose list, click Items on Sheet2 to display the available items on Sheet2 .
In the Item to publish list, click PivotTable .
Select the AutoRepublish every time this workbook is saved check box.
Click Publish to publish the PivotTable to a webpage. Excel will update the contents
of the webpage whenever a user saves the ShipmentSummary workbook.
CLEAN UP Close the ShipmentSummary workbook, saving your changes if you