Tuesday, 27 November 2012

Error in Excel service SharePoint The workbook cannot be opened.


I have start working on it,
Configure Excel services properly, Created library for Excel document, Documents are uploaded properly, but  i was unable to open the Excel file in Browser , also unable to chart control with excel sheet,

After Checking the log file i got following error in Log.

Result=Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: The workbook cannot be opened.    
 at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethodCore(WebMethodType webMethodType, WebMethodBehaviorAttribute webMethodBehavior, CommandParameter parameter, CoreWebMethod coreWebMethod)    
 at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethod(WebMethodType webMethodType, WebMethodBehaviorAttribute webMethodBehavior, CommandParameter parameter, CoreWebMethod coreWebMethod)


I have tired many solutions that are given on different blogs but nothing is working for me.


Solution.
i delete my current Excel service and configured it again.  its start working.

1 comment:

  1. Hi,

    I also got same error and I checked for the permission given in SQL for the application pool, came to know that it was giving log in failed for SQL authentication for appPool account, I gave rights of db owner and security admin to this spappPool account and it worked for me.

    ReplyDelete