Chapter overview: Configure Excel Services

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

Configure Excel Services in Microsoft Office SharePoint Server 2007 to centrally manage user access to system resources and external databases. From the Central Administration Web application in Microsoft Office SharePoint Server 2007, you can configure the SharePoint document libraries, UNC paths, and HTTP Web sites from which Excel Calculation Services can open workbooks.

You can also configure which external databases workbook authors are allowed to access. You can configure restrictions on the use of data connections, single sign-on (SS0) authentication, and the use of user-defined functions.

About Excel Services configuration

  • Trusted file locations   These are SharePoint document libraries, UNC paths, or HTTP Web sites that have to be explicitly trusted before Excel Calculation Services is allowed to access them. For more information, see Add a trusted file location.

  • Single sign-on   SSO enables authentication against external data sources without having to provide authentication credentials more than once. SSO authentication is required in a trusted subsystem environment. For more information, see Start the Single Sign-On service and Manage settings for single sign-on.

  • Trusted data providers   These are databases that reside outside of the Excel Services farm and that Excel Calculation Services is explicitly configured to trust when processing data connections in workbooks. Excel Calculation Services attempts to process a data connection only if the connection is to a database that has been added to the Excel Services trusted data providers list. For more information, see Add a trusted data provider.

  • Trusted data connection libraries   These are SharePoint document libraries that contain Office data connection (.odc) files that are used to manage workbook connections to trusted data providers. In the trusted subsystem model, front-end Web servers and application servers running Excel Calculation Services trust the accounts of the associated Office SharePoint Server 2007 applications. For more information, see Add a trusted data connection library.

  • User-defined functions   These are functions that enable users to extend the functionality of Excel Web Services. For more information, see Enable user-defined functions.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable books for Office SharePoint Server 2007.

See Also


Plan Excel Services security