How to: Trust a Location
The workbooks that you want to access must be placed in a trusted location. If not, the calls to open the workbook will fail. This example shows you how to trust a location using the SharePoint 3.0 Central Administration page.
You can also trust a location by using script. For more information, see the Office SharePoint Server 2007 TechCenter. You can also find a sample in Walkthrough: Developing a Custom Application Using Excel Web Services.
To trust a location
On the Start menu, click All Programs.
Point to Microsoft Office Server and click SharePoint 3.0 Central Administration.
On the Quick Launch, click your Shared Services Provider (SSP) link—for example, "SharedServices1"—to view the Shared Services home page for that particular SSP.
On the Shared Services home page, in the Excel Services Settings section, click Trusted file locations.
On the Excel Services Trusted File Locations page, click Add Trusted File Location.
On the Excel Services Add Trusted File Location page, in the Address box, type the location to save your workbook—for example, http://MyServer002/Shared%20Documents.
Under Location type, click the appropriate location type. In this example, select Windows SharePoint Services.
Under Trust Children, select Children trusted if you want to trust child libraries or directories.