Tuesday, May 25, 2010

SharePoint 2010 Excel Services error: The workbook cannot be opened.

In our SharePoint 2010 portal, we have recieved an error "The workbook cannot be opened" when we try to open Excel files in web pages or when we try to use the Excel Web Access Web Parts.

The logs are not of much help as they donot contain details about the cause for the error.

Error info from SharePoint log:

Utils.ExecuteWebEventHandler: An exception occured Microsoft.Office.Excel.WebUI.ExcelWebRendererException: The workbook cannot be opened. ---> 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) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.OpenWorkbook(String u... e9b4f581-c314-4f43-b3e8-60257ead66a0


...rl, OpenWorkbookFlags flags, CommandParameter commandParameter, CultureCommandParameter cultureParameter, String subscriberId, OpenWorkbookOutFlags& outFlags, OpenWorkbookOutParameters& outParameters) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerLoadBalancer.<>c__DisplayClass3.b__2(ServerSession newServerSession) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.LoadBalancer.ExecuteNewSessionMethod(CreateServerSessionMethod createServerSessionMethod, CoreNewSessionMethod newSessionMethod, String workbookUrl) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerLoadBalancer.OpenWorkbook(String url, OpenWorkbookFlags flags, CommandParameter commandParameter, CultureCommandParameter cultureParameter, String subscriberId, O... e9b4f581-c314-4f43-b3e8-60257ead66a0
...penWorkbookOutFlags& outFlags, OpenWorkbookOutParameters& outParameters, ServerSession& serverSession) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerSession.OpenWorkbook(String url, OpenWorkbookFlags flags, CommandParameter commandParameter, CultureCommandParameter cultureParameter, OpenWorkbookOutFlags& outFlags, OpenWorkbookOutParameters& outParameters, ServerSession& serverSession) at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbookAndUpdateState(String sessionId, CommandParameter commandParameter, OpenWorkbookFlags flags, String plainTextWorkbookUrl) at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbook() --- End of inner exception stack trace --- at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbook() at Microsoft.Office.Excel.WebUI.Util... e9b4f581-c314-4f43-b3e8-60257ead66a0
...s.ExecuteWebEventHandler(CoreWebEventHandler coreWebEventHandler, CoreWebEventHandler baseClassHandler, Object param, IMainControl mainControl) e9b4f581-c314-4f43-b3e8-60257ead66a0
InternalEwr.RenderWebPart: Finished rendering internal EWR e9b4f581-c314-4f43-b3e8-60257ead66a0

Resolution:

Finally the problem was resolved after deleting and creating Excel Services Application again in Cental Admin

Navigate to SharePoint 2010 Central Admin > Application Management
Under the Service Applications section, click the "Manage service applications" link


Select the Excel Services Application and delete it.



The confirmation screen looks like the one below:



Create a new Service Application by clicking on the "New" button:



Create a new Excel Service Application and choose Application Pool as required:



Do an IISRESET finally

6 comments:

  1. Great advice...i had this issue and this suggested fix worked!

    ReplyDelete
  2. great work...thank you

    ReplyDelete
  3. Worked like a charm. Thanks for the advice and clear instructions.

    ReplyDelete
  4. That worked !! thank you

    ReplyDelete
  5. Worked for me as well. Had been banging my head against this!

    ReplyDelete