Show All

Put Excel data on a Web page

1. Open or select the workbook that contains the items you want to publish.
2. 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.

3. Click Publish.
4. 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 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.
5. 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.

   • Be sure the Add interactivity with check box under Viewing options is cleared.
   • For a filtered range, Web page viewers can see only the data that was not filtered when you published the range. However, all data in the range is published to the Web page. Filtered (hidden) data can be viewed by viewing the HTML source code for the page.
   • You cannot publish an entire workbook without interactivity in the Publish dialog box. Instead, click Save As Web Page on the File menu, and instead of clicking Publish, select Entire Workbook in the Save as Web Page dialog box and make sure the Add interactivity box is cleared.

   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, 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, 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, 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.

     Notes

     • Browser users must have Microsoft Internet Explorer 4.1 or later and an appropriate Microsoft Office license to work with spreadsheets, charts, or PivotTable lists published interactively from Microsoft Excel.
     • You cannot open and modify interactive Web pages in Excel, so it's a good idea to save a copy of the original workbook from which you publish in case you want to make changes in Excel and republish.
6. To add a title over the published selection, click Change under Publish as. Type the title you want, and then click OK.
7. Next to the File name box, click Browse, and locate the drive, folder, Web folder, Web server, or FTP 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 file.
8. To view the Web page in your browser after you publish it, select the Open published Web page in browser check box.
9. 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.
10. 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.