SharePoint Excel Service

When user use the document library at first time, the excel file is trying to open using Excel service in web browser not client’s excel program.

However if your system administrator didn’t install Excel service you will have Error message

(Excel Services – We’re sorry. We ran into a problem completing your request. Please try that again in a fee minutes.)

So install the Excel service in Central administration following this instructions : https://technet.microsoft.com/en-us/library/jj219698.aspx

– register managed account

– grant content database access to the managed account using powershell script

– start the Excel Calculation Services service

– create an Excel Services service application

By default “Open Documents in Client Applications by Default” site collection feature is not activated so if you activate this feature the excel document will be opened using client’s excel program.

Comparing Excel Online, Excel Services, and Excel Web App

https://support.office.com/en-ie/article/Comparing-Excel-Online-Excel-Services-and-Excel-Web-App-855ee1a3-9263-425d-bccd-4070d2413aa7

BI in Excel and Excel Services

http://blogs.technet.com/b/tothesharepoint/archive/2013/04/05/bi-in-excel-and-excel-services.aspx

Co-Authoring Documents with SharePoint 2013

http://en.share-gate.com/blog/co-authoring-documents-sharepoint-2013

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: