Interactive Excel Spreadsheets

If you have the proper software installed on your computer you can interact with a Web Excel spreadsheet using your browser even though you do not have Excel installed.  That is, you can edit the cells (those not protected) and view the resulting changes.  Since no cells are protected from change in this example, you may make any changes desired including adding other income or expense items, editing formulas, etc..  To return the spreadsheet to its original form, reload the page by clicking your browser's Go button (Refresh will not usually work).   You can also save the page to your hard-drive for future use.

Requirements for Viewing Interactive Data 
You must have the following installed on your computers to view interactive Microsoft Excel data on a Web page:

• Microsoft Office Web Components (Office 2000 or later)
• Microsoft Internet Explorer version 4.01 or later (Internet Explorer 5 is available with Microsoft Office 2000)

If you're using Microsoft Internet Explorer 4.01 or later, changes that you make to a spreadsheet are retained while you are working in the browser, even when you return to the spreadsheet after viewing other Web pages. You cannot save your changes in the browser to a file, however.

Note   If you close the browser, or if you click the Address bar and press ENTER, changes you made to the spreadsheet will be lost.

To make changes to a spreadsheet and save your changes in a file, you need to open the spreadsheet in a design program, such as Microsoft FrontPage 2000 or data access page Design view in Microsoft Access. You can also export the spreadsheet to Microsoft Excel and save the spreadsheet as an Excel workbook.

Exporting a Web spreadsheet to a Microsoft Excel workbook

If you want to perform additional analysis on the data in the spreadsheet, save changes you've made to the spreadsheet, or take advantage of Excel 2000's printing features, you can export the spreadsheet to an Excel 2000 workbook.

• On the toolbar in the spreadsheet, click Export to Excel  to run or switch to Excel and display the data in a workbook.

Note:  When you export data from a spreadsheet to Excel, only the values and formulas are exported. Hyperlinks continue to work, but links to other data are changed to their last resulting value, and no links to the source data are maintained.  For additional details regarding exporting Web spreadsheets, see the Excel's Help.