This lesson shows how
easy it is to save spreadsheets and charts to your workgroup Web.
Note:
This tutorial requires Excel 2000 and Office Web Components.
1. Right-click
the sales.xls link, and
click Save Target As.
2. Save the file to your hard drive.
3. Start
Microsoft Excel 2000.
4. On the File
menu, click Open.
5.
Locate sales.xls on your hard drive and
double-click.
This
spreadsheet is designed to forecast international sales into the year 2002
and uses a chart to display the results. You can publish this spreadsheet,
including the chart, as a Web page and share it with your team.
6.
On the File menu, click Web Page Preview. This opens up the
file in Internet Explorer that closely resembles the file in Excel format.
7. To
save the file, return to Microsoft Excel, and click Save
as Web Page on the File
menu, which saves this file on your hard drive.
8. Close
Microsoft Excel.
9. Use
Microsoft Windows Explorer to locate the file on your hard drive and
double-click the file to open it in Internet Explorer.
When
you saved a file as HTML in previous versions of Microsoft Excel, there
was no way to open up that file again in Excel. It was a one-way
operation. In Excel 2000, you can “round trip” Web pages back into
Excel, maintaining all of the original formatting and calculations.
10. To open your Web page in Excel, click Edit on the Internet Explorer toolbar. This will launch Microsoft Excel and open the spreadsheet so that it includes all the formulas and formatting of the original.
Excel 2000 allows you to publish a spreadsheet as a Web page without any loss of information or fidelity. Information in the browser is static, however, there is no way to interact with the data without going into Excel.
Excel 2000 also allows you to save a spreadsheet as an interactive Web page that allows manipulate of live data from inside Internet Explorer.
11. Open sales.xls in Microsoft Excel.
12. Select the chart by clicking on it.
13. On
the File menu, click Save as Web Page.
14. Click
Republish: Sheet and check the Add interactivity box.
15.
Change the File Name to interactive sales.htm.
16. Click
Save.
17.
Locate interactive sales.xls on your hard drive and double-click it to
open that page in Internet Explorer.
18. Enter
10,000,000 in the Germany row for the year 2001. Notice that the totals
were automatically recalculated and the chart was updated.
Microsoft Excel 2000 allows you to publish spreadsheets as high fidelity, static Web pages that work in most browsers, and as rich, interactive Web pages that use the Office Web Components to let you manipulate data from inside Internet Explorer.
