Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Posts Tagged ‘excel services’

Configure Excel Services

Posted by Paul on December 26, 2014

In this article we can explore how to configure excel services in SharePoint 2013.

Excel Services Application

Excel Services Application is required to be created as the first step of configuration. Open Central Administration > Manage service applications link.

image

Ensure that the following service application named Excel Service Application is created.

image

If it is not created, choose New > Excel Service Application link to create one.

Excel Calculation Services

Excel Calculations Services needed to be turned on. Open Central Administration > Manage services on server link.

image

Ensure that the following service Excel Calculation Services is started.

image

If it is not started, you can click the link to start it.

Manage Excel Service Application

Click the Excel Service Application from Service Applications. You will get the screen below.

image

Global Settings allows load balancing, memory management, security, external data, cache etc.

Trusted File Locations allows specifying trusted file location from which the Excel Services can load files.

Trusted Data Providers allow managing of external data providers like SQL Server.

Trusted Data Connection Libraries allows management of trusted data connection libraries.

User Defend Function Assemblies allows management of custom assemblies.

Data Model Settings allows management of SQL Server Analysis Services instances.

References

http://technet.microsoft.com/en-us/library/jj219698(v=office.15).aspx

Summary

In this article we have explored how to configure excel services in SharePoint 2013. In the upcoming articles we can explore loading & manipulating an excel file using the excel services.

Advertisements

Posted in SharePoint, SharePoint 2013 | Tagged: , | Leave a Comment »