Illustration of How to
Publish an Interactive Excel Spreadsheet in HTML
Bob Jensen at Trinity University
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:
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.
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.