Leading the way in Microsoft Office Development

Saving a Worksheet as Interactive HTML

Excel 2000 can save HTML files that when displayed the browser let the user interact with it, entering and changing numbers etc.

This feature is often referred to as publishing and is only limited to a single worksheet.

(File > Save As Web Page).

In the Save As dialog box choose Selection: Sheet option and place a checkmark next to add interactivity. Click the Publish button.

Another dialog box will be displayed. Accept the defaults and click Publish.

Now display this file in a browser.

You will see that it actually displays a worksheet like object that is interactive.

All the complexity is handled by an ActiveX control and all the information is contained in a single HTML file.

The end user must have Office 2000 installed on their computer in order to see the interactive worksheet in their browser.