How to: Trust a Location
Applies to: SharePoint Server 2010
Workbooks that you want to access must be placed in a trusted location. If they are not, calls to open the workbooks will fail. This example shows you how to trust a location by using the SharePoint Central Administration page.
You can also trust a location by using Windows PowerShell. For more information, see the Microsoft SharePoint Server 2010 IT Pro and administration documentation on TechNet.
Tip
For more information about administration improvement and to view screen shots of the Trusted File Locations page, see the blog post Excel Services in SharePoint 2010 Administration Improvements.
To trust a location
On the Start menu, click All Programs.
Point to Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Central Administration.
On the SharePoint 2010 Central Administration page, under Application Management, click Manage service applications.
On the Manage Service Application page, click Excel Services Application.
On the Manage Excel Services Application page, click Trusted File Locations.
On the Excel Services Application Trusted File Locations page, click Add Trusted File Location.
On the Excel Services Application Add Trusted File Location page, in the Address text 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 SharePoint Foundation.
Under Trust Children, select Children trusted if you want to trust child libraries or directories.
Click OK.
See Also
Tasks
Walkthrough: Developing a Custom Application Using Excel Web Services
Step 3: Deploying and Enabling UDFs
How to: Save from Excel Client to the Server