Publishing and Viewing an Excel Workbook in an Excel Web Access Web Part

One of the real strengths of SharePoint is the ability to view and manage information without having to leave SharePoint or open the document source directly. The Excel Web Access Web Part allows you to see and manipulate Excel Workbook data without actually opening Excel or even having Office Excel 2007 installed on your local computer. An example of a page showing Web Access Web Parts in a Web Part page can be seen in Figure 18-1.

Warning

Verify that Excel Calculation Services is running by going to Central Administration. If the service is stopped, you will be unable to perform the following exercises.

Excel Web Access Web Parts in a Web Part page

Figure 18-1. Excel Web Access Web Parts in a Web Part page

Tip

See Chapter 8 for more information on Web Parts and Web Part pages.

Enabling Trusted File Locations in Central Administration

Prior to publishing an Excel workbook in SharePoint, you (or your SharePoint administrator) must set up a trusted file location for your workbooks within the Shared Service Provider (SSP):

  1. Open SharePoint Central Administration.

  2. In the Quick Launch menu to the left, under Shared Services Administration, click the relevant SSP to open it.

  3. Under Excel Services Settings, click Trusted File Locations, and select Add Trusted File Location from the list.

  4. When the Excel Services Add Trusted File Location page opens, as in Figure 18-2, in the ...

Get SharePoint 2007: The Definitive Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.