Excel Services administration (SharePoint Server 2010)

Published: May 12, 2010

Excel Services is a Microsoft SharePoint Server 2010 service application that allows users to share and view Microsoft Excel workbooks. The service application also enables data-connected Excel Services workbooks and work sheets to be refreshed and updated from a variety of data sources.

In this section:

• Manage Excel Services custom applications (SharePoint Server 2010)

  Excel Services in Microsoft SharePoint Server 2010 provides several methods to extend the capabilities of Excel Calculation Services, customize applications and workbooks, and also allow developers to incorporate Excel Services into their solutions.

• Manage Excel Services connections (SharePoint Server 2010)

  Excel Services in Microsoft SharePoint Server 2010 provides the ability to connect to external data sources and refresh this data. Deploying Excel workbooks with external data connections is the focus of this article.

• Manage Excel Services trusted locations (SharePoint Server 2010)

  This article explains the trusted file location for Excel Services in Microsoft SharePoint Server 2010.

• Use Excel Services with Secure Store (SharePoint Server 2010)

  This article explains how to set up and configure Secure Store Service for Excel Services Application in Microsoft SharePoint 2010 Products and then set the credentials for an application ID and finally add it to your Excel Services application.

• Manage Excel Services with Windows PowerShell (SharePoint Server 2010)

  This article gives a high level overview of Windows PowerShell behavior for Excel Services in Microsoft SharePoint Server 2010. Excel Services administrators can use Windows PowerShell to fully script Excel Services setup and deployment, configuration options, and change all settings during runtime as part of Microsoft SharePoint Server 2010 deployments.