Illustration of How to Publish an Interactive Excel Spreadsheet in HTML
Bob Jensen at Trinity University

• To run the interactive spreadsheet, the browser you are using now must have Internet Explorer 4.0 or higher.  You can test for interaction by entering new data in Cells B11, B12, and/or B13.  Click here to view the interactive spreadsheet.
  
  
• Click here to view the instructions on how to save an Excel spreadsheet as an interactive (dynamic) HTML document.

Dynamic (Interactive) Spreadsheet Example --- Test for interaction by entering new data in Cells B11, B12, and/or B13

Instructions on how to save an Excel spreadsheet as a dynamic (interactive) HTML document.

Note from Jensen:  I prefer to follow the steps below to create a dynamic (interactive) spreadsheet HTML file.  Then I insert that file within a file using the following steps:

• Click on (Edit, Select all) and copy the entire dynamic spreadsheet file to the clipboard.
• Go to an existing HTML file and find an insertion point within your existing text.
• Paste the dynamic spreadsheet into the HTML document.
• If you follow these steps, you do not have add all the header information to the original dynamic spreadsheet file.

The following general instructions are given in the Excel 2000 Help pages:

Click the chart or the chart sheet that you want to put on a Web page.

On the File menu, click Save as Web Page. 

Click Publish.

Under Viewing options, select the Add interactivity with check box. (Chart functionality is automatically selected.)

To add a title to the published chart, click Change, type the title you want, and click OK.

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

If you want to view the Web page in your browser after you publish it, select the Open published Web page in browser check box.

Click Publish. Notes

The associated data for the chart is also placed on the Web page when you use interactive functionality. When you save a chart, an associated interactive spreadsheet is included, and when you save a PivotChart report, an associated PivotTable list is included.

Some formatting and features for your chart are not retained when you save it as a Web page.

You can learn more about publishing charts.

After you save your chart as a Web page, you can't open and modify the .htm file in Microsoft Excel without losing formatting and functionality. Use Microsoft FrontPage 2000 or data access page Design view in Microsoft Access 2000 to modify the Web page.

Return to top of page.