SharePoint 2013 – Create Excel Services Service Application
October 29, 2013 6 Comments
Here we begin with the configuration of the BI features of SharePoint 2013.
From Central Admin, Select Application Management, Manage Service Applications. New Excel Service Application.
Select Excel Services Application and enter a name for the service and select the BI App Pool. Leave the rest as defaults.
Once complete select the Excel Services Service and click Manage.
Here you can configure necessary Excel Services settings. I will go through the key ones to configure or check.
Start with Trusted File Locations
Click Add Trusted File Location
Add any URLS to sites or Excel Libraries that are allowed. See examples below. Substitute URLs for your own. Allow children so sub sites and libraries will work also.
Change workbook size if required and increase image size from default of 1MB as you will soon recieve a request from your users if you don’t.
I prefer to remove the warning when refreshing data in workbooks. Default is ticked.
Press OK when complete.
Next go to Trusted Data Connection Libraries and add any data connection library locations here.
Create an Excel Document Library
Select “Add an App” from the site settings menu on the top right of the screen.
Select Document Library
Then Select Advanced
Name the library and enable version history if required (recommended for production).
Add a Data Connection Library
I would recommend creating the library with a name that has no spaces in the title. This is to make it easier for users who may want to deploy data source from Visual Studio into SharePoint Data source Libraries. Just one less thing to worry about if you can do this.
Also ensure any data source libraries are added to the trusted locations in Excel Services AND the correct data source library is added i.e. for Excel add the standard one and not the Data Sources for Performance Point.
Thanks for reading !
We will move onto PowerPivot in the next article.