Using the Spreadsheet Web Part
Publishing a spreadsheet as an interactive web page is cool, but unfortunately the data on the page can't be saved. You can view the page, make some changes, and see the result, but the next person to view the page won't see your work.
To create interactive spreadsheets that can save data, create a new web part page and add a spreadsheet web part. The spreadsheet web part is included with the Office 2003 web parts download available from Microsoft. Your SharePoint administrator must install that download on your SharePoint server before you can complete the tasks in this section.
To create a page with a spreadsheet web part:
From the SharePoint site home page, choose Create → Web Part Page.
Enter a name for the new page, choose a layout, select the document library to store the page in, and click Create. SharePoint displays the new page in edit mode.
In the web part task pane, select Virtual Server Gallery. You'll see a list of the web parts installed on your server.
Drag the Office Spreadsheet web part from the task pane to a web part zone on the page. SharePoint adds the web part to the page, as shown in Figure 5-24 .
Close the web part task pane and click OK to save the changes.

Figure 5-24. Creating a web part page containing a spreadsheet
Once you've created a web part page containing a spreadsheet web part, you can edit the cells on the spreadsheet directly ...