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”.