How to Configure Excel Services in SharePoint 2010

In this post, I will show how to configure excel Services in SharePoint 2010.

Following are the steps to configure excel services

1. Click Application Management
2. Click Manage Service Applications
3. Click Secure Store Services Applications
4. Click on new and fill the necessary details as shown below

a. Target Application ID: SP2010ExcelServices

b. Display Name: SP2010ExcelServices

c. Contact Email:

d. Target Application Type: Group

e. Target Application URL: None and then click next.

5. Keep the default settings and click next

6. Fill the below details

a. Target Application Administrators: Domain\Administrator

b. Members: Domain\Domain Users and click ok.

7. Once the target application ID is created, Checked the checkbox next to SP2010ExcelServices and click on generate new key in the ribbon.

8. Enter the Pass Phrase

9. Once again checked the checkbox next to SP2010ExcelServices and click on set credentials in the ribbon.

10. Once again click Application Management, Manage Service Applications and then Excel Services Applications.

11. Click Global Settings, Scroll to the bottom of the page and in the Application ID field under external data, enter SP2010ExcelServices then click OK.