Roux Visser’s SharePoint Blog

To take full advantage of the business intelligence capabilities of Office SharePoint Server 2007 you need to start and configure Excel Calculation Services. Instructions for doing this are provided below.

Note: Excel Services is only available if you use a product key that activates the Enterprise version of Office SharePoint Server 2007. 

Start and configure Excel Calculation Services

1. On the SharePoint Central Administration home page, click Administrative Tasks.
   
2. On the Administrative Tasks page, click Add Excel Services Trusted Locations.
   
3. On the Add Excel Services Trusted Locations page, in Action, click Add Excel Services Trusted Locations.
   
4. On the Excel Services Trusted File Locations page, click Add Trusted File Location.
   
5. In the Location section, in Address, type the address of the trusted file location. It is recommended that the trusted file location be an Office SharePoint Server 2007 site, but you can also specify universal naming convention (UNC) paths or HTTP Web sites.
   
6. In Location Type, click Windows SharePoint Services if you specified an Office SharePoint Server 2007 site, click UNC if you specified a UNC path, or click HTTP if you specified an HTTP Web site.
   
7. In the External Data section, in Allow External Data, select the trust level for external data sources that you want to enable by doing one of the following:
   

• Click None to prevent Excel Calculation Services from processing connections to any external data connection.
  
• Click Trusted data connection libraries only to prevent Excel Calculation Services from processing connections to external data sources that are embedded within workbooks. This setting permits Excel Calculation Services to process links to trusted data connection libraries.
  
• Click Trusted data connection libraries and embedded to permit Excel Calculation Services to process direct connections to external data sources that are embedded within workbooks. This setting also permits Excel Calculation Services to process links to trusted data connection libraries.