Vue d’ensemble du chapitre : configuration d’Excel Services

Mise à jour : 2009-03-26

Configure Services Excel dans 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 Services de calcul Excel 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 Services de calcul Excel is allowed to access them. For more information, see Ajouter un emplacement de fichier approuvé.

  • 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 Démarrer le service d’authentification unique and Gérer les paramètres d’authentification unique.

  • Trusted data providers   These are databases that reside outside of the Services Excel farm and that Services de calcul Excel is explicitly configured to trust when processing data connections in workbooks. Services de calcul Excel attempts to process a data connection only if the connection is to a database that has been added to the Services Excel trusted data providers list. For more information, see Ajouter un fournisseur de données approuvé.

  • 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 Services de calcul Excel trust the accounts of the associated Office SharePoint Server 2007 applications. For more information, see Ajouter une bibliothèque de connexions de données approuvée.

  • User-defined functions   These are functions that enable users to extend the functionality of Services Web Excel. For more information, see Activer les fonctions définies par l’utilisateur.

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.

Voir aussi

Concepts

Planifier la sécurité Excel Services