Making Excel Interactive on the Web

If you want others to be able to interact with the data on a Web page, you can make the data interactive. Depending on the choices you make, people can perform such actions as filtering or entering new values for calculations. Much of the data in Excel for Windows can be saved with interactivity, but some can't. Excel for the Macintosh can't save it's data to be interactive.

 

Data that can be interactive:
    • Range of cells or a simple list
    • Filtered list
    • To put an interactive chart on a Web page, you must save it separately by clicking Save As on the File menu.
    • Modified data on an interactive Web page that was previously saved by Excel

 

Data that cannot be non-interactive
    • Entire workbook
    • Modified data on a non-interactive Web page that was previously saved by Excel.

---

---

How To Save a Worksheet as Interactive

1. Open the desired worksheet if it is not already open.
2. Make sure that all the work is saved.
3. On the File menu, click Save as Web Page.
4. In the Choose box, select desired Workbook, Sheet, or Range of Cells.
5. If needed, change where the file will be saved on your computer.
6. To add a title to the saved worksheet, click Change Title, enter the title, and click OK.
7. Click Publish.
8. Under Viewing options, select the Add interactivity check box. (Spreadsheet functionality is automatically selected.)
9. If you want to Web page to be updated when the file is saved, check "AutoRepublish every time this worksheet is saved.
10. If you want to view the Web page in your browser after you save it, select the "Open published Web page in browser" check box.
11. Click Publish.

---

How To Save a Chart as Interactive

When you save an interactive chart to the Web, you must keep the following in mind:

• Some formatting and features for the chart are not retained when you save it as a Web page.
• After you save the chart as a Web page, you can't open and modify the .htm file in Excel without losing formatting and functionality.

1. Click the chart or the chart sheet that you want to put on a Web page.
2. On the File menu, click Save as Web Page.
3. If needed, change where the file will be saved on your computer.
4. Under Viewing options, select the Add interactivity with check box. (Chart functionality is automatically selected.)
5. To add a title to the chart, click Change, type the title you want, and then click OK.
6. Click Publish.
7. If you want the Chart to be updated when the file is saved, check "AutoRepublish every time this worksheet is saved.
8. If you want to view the Web page in your browser after you save it, select the "Open published Web page in browser" check box.
9. Click Publish.

---

Note on Saving Interactive Web Pages

When publishing an interactive Web page, you may get a message stating that the 1904 date system will not work and dates will be converted to the 1900 Date System, this is OK.

 

To turn off the 1904 Date System:

1. Go to Tools menu and choose Options.
2. Select the Calculation tab.
3. De-select 1904 Date System.

In Microsoft Excel for Windows, days are numbered from the beginning of the century; the date serial number 1 corresponds to the date January 1, 1900. Microsoft Excel for the Macintosh uses the 1904 date system; the date serial number 1 corresponds to January 2, 1904.

 

If you open in Microsoft Excel for Windows a file created in Microsoft Excel version 2.0 or later for the Macintosh, Microsoft Excel recognizes the file format and automatically changes dates to the 1900 date system. Similarly, if you open a Microsoft Excel for Windows file on a Macintosh, Microsoft Excel changes dates to the 1904 date system.