Thursday, May 28, 2015

There was an error in communicating with Excel Calculation Services


Error Statement

Following errors were logged in Windows Events Viewer and SharePoint ULS log.

There was an error in communicating with Excel Calculation Services http:// Servername:32843/aaf0ae2450e64fa088df4fbcbaf32bb7/ExcelService*.asmx exception: The remote server returned an error: (503) Server Unavailable.[Session:User: ActiveDirectory\User].

 

Unable to reach Excel Calculation Services http://Servername:32843/aaf0ae2450e64fa088df4fbcbaf32bb7/ExcelService*.asmx.[Session:User: ActiveDirectory\User]

 

 

 

Cause of error:

Application pool on WFE server get stopped causing requests generated from this particular machine to time out.

 


Application pool stopped because the service account used to configure Excel Calculation services was no more member of the local Administrator group.

Service account used in application pool should be there in Administrator group.

 

 

 

Excel Calculation services requires permission on Office Server\15.0 register value to perform excel operations. As registry values has only administrator permission, so the exclusion of service account from Administrator group do not allow it to perform its tasks.

Solution:

Added service account to local administrator group.

Restart “World Wide Web Publishing Service”.

 

 

6 comments:

  1. Not only that, but if the final column included a formula - as they often do for totalling purposes - Excel 2003 would automatically repeat it as soon as the column was reached.excel dashboard software

    ReplyDelete
  2. Simply duplicate from Excel and glue straightforwardly to the introductions. Excel spreadsheet expert

    ReplyDelete
  3. Jesus bless us, your blog will be the idea specialist for my own business enterprise. My spouse and i want we can perform a few online business with each other. help with excel spreadsheets

    ReplyDelete
  4. This straightforwardness is Excel's most noteworthy strength however there are two normal circumstances in which it turns into a shortcoming. excel consultants near me

    ReplyDelete
  5. Microsoft Excel is a powerful spreadsheet application, or workbook. A workbook is a computer application that allows a user to enter a series of numbers, along with other data. The purpose of the Excel application is to allow users to collect like data in a specific location for current and/or future use. ppt translator

    ReplyDelete
  6. He realizes how Excel can be useful for both little and huge associations by giving preparation to individuals from an assorted word related foundation from financiers, engineers, bookkeepers to telecom laborers, oil laborers and protection specialists.college placement cells database

    ReplyDelete