SharePoint 2013 There was an error in communicating with Excel Calculation Services error while opening excel file in browser
Check out Best Alternative to InfoPath -> Try Now
This SharePoint tutorial explains, how to fix error “There was an error in communicating with Excel Calculation Services. Unable to process the request. Wait a few minutes and try performing this operation again” which comes while trying to open an excel file in the browser in SharePoint 2013.
Ok, When I open the ULS logs I got the error message as There was an error in communicating with Excel Calculation Services.
There was an error in communicating with Excel Calculation Services
Here the reason might be the Excel Services may not be working properly. Either you can restart the central administration or you can restart the application pool running the excel services application.
- For this Open IIS (Start –>Run –> inetmgr).
- Then Click on SharePoint Web Services under Sites which will display the services.
- Click on each GUID –> Change the view from Features View to Content View
- On finding ExcelService.asmx -> Right click that web service -> Manage Application -> Advanced Settings and then Identify the Application Pool
- Now in IIS -> Application Pools -> choose the particular Application Pool we got in the previous step ->Recycle.
After this try opening the excel file in the browser. It should open without error.
You may like following SharePoint tutorials:
- 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
- Unable to create or access workbook cache. Excel Services Application is unable to function without a workbook cache Event ID 5226
- The workbook cannot be opened because it is not stored in excel services SharePoint 2010
- Unable to reach excel calculation services error event id 5231 error in SharePoint
Download SharePoint Online Tutorial PDF FREE!
Get update on Webinars, video tutorials, training courses etc.