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.
Hi,
ReplyDeleteI 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.