O'Reilly logo

SharePoint 2007: The Definitive Guide by Christopher J. Regan, Piotr Prussak, Christopher Pragash, Joris Poelmans, Nilesh Mehta, Jason Medero, Michael Lotter, Murray Gordon, Bob Fox, Christopher M. Buechler, James Pyles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required