Microsoft® SharePoint® Server 2007 Bible

Optimizing Excel Services

Excel Services allows you to reuse your existing corporate spreadsheet assets in SharePoint without having to convert the file format. It also allows you to use and connect your spreadsheet data while protecting and securing the business logic and data contained in your spreadsheets. You must be running MOSS to use Excel Services.

Excel worksheet functionality can extend to external data sources, user-defined functions, and programmatic access to services, so it’s important to secure the file locations and data sources that you will be using to support your Excel Services. Doing this enables you to take advantage of the Excel Services functionality without exposing your SharePoint infrastructure to malicious or bad behavior.

This section covers how to configure Excel Services to be secure and usable, and have high performance.

Configuring Excel Services settings

To configure your Excel Services settings and optimize its security and performance, follow these steps:

1.	Open the administration page for your Shared Service provider.
2.	Select Edit Excel Services settings in the Excel Services Settings section.
3.	In the Security section, select whether you would like to use Impersonation or the Process account to access workbooks that are not stored on SharePoint. If you select impersonation, Excel Services will use the credentials of the service account.
4.	In the Security section, select whether encryption is required between the Excel Services front end ...