Here we will discuss how we can resolve Unable to reach excel calculation services error event id 5231.
The error comes as: Unable to reach excel services.
– Download documents from Document Library using SharePoint Server Object Model
– Retrieve list data using AngularJS REST API in SharePoint 2013
– Deploy SharePoint 2013 designer workflow to different site in SharePoint 2013
Cause : The Excel Services Application server computer is in a non-valid state and may need to be restarted.
Symptoms: One or more of the following symptoms might appear:
Delayed load times for workbooks.
Workbooks fail to load.
In our case this is occurred because of services was stopped. But there will other reason also cause of this error.
1. Restart excel calculations services
a. Go to central administrator and open Manage services under application Management
b. Check excel services application is started, if it is stop restart this service.
2. Recycle app pool
a. Go to IIS Manger and open application pool
b. Select application and right click and recycle selected application pool.
c. Once all done reset IIS
Note: Make sure that the account you are using for excel calculation service is working properly i.e. not locked!
Reboot the server