- Open or select the workbook that contains the items you want to publish.
- On the File menu, click Save as Web Page.
If you have already selected the item you want to publish, or want to publish an entire workbook without interactivity, you can select the options you want in the Save as Web Page dialog box, click Save, and you're done. Otherwise, continue with the steps listed below.
- Click Publish.
- Under Item to publish, click what you want to publish in the Choose box.
Choosing items to publish
To select the worksheet or item that you want to publish, select one item from the Choose list. You can publish only one item at a time. To publish another item, select the new item and repeat the publishing procedure. The following list outlines what you can publish and how to publish it.
- Entire workbooks Select Entire workbook. You can publish an entire workbook with interactivity in the Publish dialog box, but not without interactivity.
- Entire worksheets Select Items on Sheetname, and then select All contents of Sheetname.
- Items Select Items on Sheetname, and then select the item you want to publish, such as a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) or a chart. Items do not include ranges of cells.
- Ranges of cells Select Range of cells and then, if the selection box does not contain the range you want, click the worksheet (the dialog box will collapse to a selection box), select a range of cells from the Microsoft Excel workbook, and then click Expand Dialog .
- Charts Select Items on Sheetname, and then select Chart x.
- Filtered ranges Select Items on Sheetname, and then select the AutoFilter item you want to publish.
- External data ranges Select Items on Sheetname, and then select the Query item you want to publish.
- Republishing To republish a worksheet or item that you have already published, select Previously published items and then select the worksheet or item you want to republish. To prevent an item from being republished, select the item and click Remove. To continue publishing, click another item in the list.
- Under Viewing options, select or clear the Add interactivity with check box, and if necessary, click the type of functionality you want.
Publishing with or without interactivity
Publishing without interactivity
If you want users to view the data you publish but not work with it in the browser, you can publish it as noninteractive data. You can open, edit and save noninteractive Web pages in Microsoft Excel, but you cannot make any changes to the data in the browser.
Publishing with interactivity
To enable people to work with the data on your Web page in a browser, you can make your data interactive. For example, you can publish an interactive spreadsheet that calculates loan information. A user who browses to the page can enter financial information such as loan amount and interest rate to calculate a monthly payment.
- Select the Add interactivity with check box and select the type of interactivity you want from the list. The type of interactivity that's available depends on what you are publishing. For example:
- For a worksheet that contains formulas, select Spreadsheet functionality so that users of your Web page can enter new values in a cell and the formulas will automatically calculate the results.
- For a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.), select PivotTable functionality so that users of your Web page can change the layout of rows and columns to see different summaries of the source data.
- For an external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.), select PivotTable functionality so that Web page viewers can update the data from its source.
- For a filtered range, select Spreadsheet functionality.
- For a chart or PivotChart report (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.), select Chart functionality. If you try to publish all contents of a worksheet that contains a chart with interactive functionality, the chart is not included on the Web page. To put an interactive chart on a Web page, you must publish the chart separately.
- To add a title over the published selection, click Change under Publish as. Type the title you want, and then click OK.
- Next to the File name box, click Browse, and locate the drive, folder, Web folder (Web folder: A shortcut you use to save, open, copy, or delete files on a Web or FTP server. Some Web folders, such as document libraries, have functionality not available with local folders. You'll find Web folders in My Network Places or Web Folders.), Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), or FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) location where you want to save or publish your Web page. You can also choose an existing Web page to append to or replace as long as you have permission to modify the Web page and have access to the HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file.
- To view the Web page in your browser after you publish it, select the Open published Web page in browser check box.
- If you expect to make changes in the workbook later and want to automatically republish the items each time the workbook is saved, select the AutoRepublish every time this workbook is saved check box.
- Click Publish.
If you are publishing to an existing Web page, click Replace file to copy over the existing page, or Add to file to append your data to the end of the Web page.