Excel Services trusted data connection libraries - SharePoint 2013

a)   In the SharePoint Central Administration website,

b)   In the Application Management section, click Manage service applications.

c)   On the Manage Service Applications page,

d)   Click the Excel Services service application that you want to configure.

e)   On the Manage Excel Services page,

f)    Click Trusted Data Connection Libraries.

g)   On the Excel Services Application Trusted Data Connection Libraries page,

h)   Click Add Trusted Data Connection Library.

i)     On the Excel Services Application Add Trusted Data Connection Library page, in the Location section, type the address of the trusted data connection library in the Address box.

j)    In the Description box, you can also type a description of the purpose for this trusted data connection library.

k)   Click OK.

Excel Services global settings - SharePoint 2013

1.   On the Central Administration home page,

2.   In the Application Management section,

3.   Click Manage service applications.

4.   On the Manage Service Applications page

5.   Click the Excel Services service application that you want to manage.

6.   On the Manage Excel Services page, click Global Settings

7.   On the Excel Services Application Settings page, update the settings that you want to change, and then click OK.