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.
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.
Figure 18-1. Excel Web Access Web Parts in a Web Part page
See Chapter 8 for more information on Web Parts and Web Part pages.
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):
Open SharePoint Central Administration.
In the Quick Launch menu to the left, under Shared Services Administration, click the relevant SSP to open it.
Under Excel Services Settings, click Trusted File Locations, and select Add Trusted File Location from the list.
When the Excel Services Add Trusted File Location page opens, as in Figure 18-2, in the ...