This tutorial, we will see how to solve Unable to reach excel calculation services error event id 5231. The error comes as: Unable to reach excel services.
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.
Unable to reach excel calculation services error event id 5231
In our case this is occurred because of services were stopped. But there will other reasons also cause this error.
Restart excel calculations services
Go to the SharePoint central administrator and open Manage services under application Management.
Check excel services application is started if it stops restart this service.
Recycle app pool
Go to IIS Manager and open the application pool and then Select the application and right-click and recycle the selected application pool.
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!
You may like following SharePoint tutorials:
- SharePoint 2013: Export survey results to excel
- Excel at SharePoint Online Management Shell
- Excel Service to import SSAS Cubes and Generating Pivot tables in SharePoint BI
- Excel service to import external database using secure store connection in SharePoint
- Configure Excel Service Application in SharePoint 2013/2016
- Creating Excel without MS-Office Installation
- Unable to create or access workbook cache. Excel Services Application is unable to function without a workbook cache Event ID 5226
- Publishing and Synchronizing Excel tables to SharePoint 2013/2016/Online Lists using Excel Add-in
- Export Excel Data to SharePoint 2013 list from Excel itself
- SharePoint 2013 There was an error in communicating with Excel Calculation Services error while opening excel file in browser
- Upload Excel Data to SharePoint using Import Spreadsheet option in SharePoint 2013
Tags: unable to reach excel calculation services, unable to reach excel calculation services sharepoint 2010, unable to reach excel calculation services sharepoint 2013, unable to reach excel calculation services 5231, sharepoint unable to reach excel calculation services
Download SharePoint Online Tutorial PDF FREE!
Get update on Webinars, video tutorials, training courses etc.