Share via

There was an error in communicating with Excel Calculation Services

  • Article

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]

 

https://1.bp.blogspot.com/-9uIjTsQj1dI/VWb-t4Eq43I/AAAAAAAAAHM/qJx-UJwbgpw/s1600/5239.png

 

https://2.bp.blogspot.com/-5rOOfzAyIx0/VWb_EoHnzkI/AAAAAAAAAHU/Tx2GEii1akc/s1600/5231.png

 

Cause of error:

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

 

https://4.bp.blogspot.com/-5-VrgP7ayHM/VWb_RVmagpI/AAAAAAAAAHc/-4rWk9hyZUw/s1600/1.png

 

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.

 

https://4.bp.blogspot.com/-efE0kSrRIvk/VWb_RnBcWEI/AAAAAAAAAHg/eQU_s1-uOuA/s1600/2.png

 

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

Solution:

Added service account to local administrator group.

Restart “World Wide Web Publishing Service”.