Skip to Main Content
Essential SharePoint
book

Essential SharePoint

by Jeff Webb
May 2005
Beginner content levelBeginner
336 pages
10h 14m
English
O'Reilly Media, Inc.
Content preview from Essential SharePoint

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:

  1. From the SharePoint site home page, choose Create Web Part Page.

  2. 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.

  3. In the web part task pane, select Virtual Server Gallery. You'll see a list of the web parts installed on your server.

  4. 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 .

  5. Close the web part task pane and click OK to save the changes.

Creating a web part page containing a spreadsheet

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint User's Guide

SharePoint User's Guide

Infusion Development Corp. (Infusion Development Corporation)
Beginning SharePoint® 2010: Building Business Solutions with SharePoint

Beginning SharePoint® 2010: Building Business Solutions with SharePoint

Amanda Perran, Shane Perran, Jennifer Mason, Laura Rogers

Publisher Resources

ISBN: 0596008805Errata Page