locked
"The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:" when trying to view excel file in web browser RRS feed

  • Question

  • I am testing MOSS for a client and I need to provide the changes they need to make to some excel files to enable them to view the files in a web browser.  I removed the headers from the worksheets and removed a data validation and I was able to then view the file in a web browser.  The problem now is that I repeat the same steps with the original file and for some reason I am again unable to view the file.
    • Edited by Mike Walsh FIN Friday, June 18, 2010 4:32 AM Getting error not needed " " around the error message is enough (and the Title is long enough in any case)
    Friday, June 18, 2010 3:57 AM

Answers

  • Hi Jim, 

    We are running Office 2007.  I have had microsoft support onto it and they found there was a picture in the header.  The picture couldn't be seen in the excel file when viewing the header and was only removed after removing headers and footers in the 'preparing the document for distribution' function.  This has solved the problem.

     

    Cheers

    • Marked as answer by kimboss Wednesday, June 30, 2010 11:43 PM
    Wednesday, June 30, 2010 11:43 PM

All replies

  • Hi,

     

    There is some unsupported features in excel services, please refer to

    http://msdn.microsoft.com/en-us/library/ms496823(office.12).aspx

     

    make sure there is no any unsupported feature in your workbook.

     

    Hope this helps

     

    Thanks!

    Stanfford

    Monday, June 21, 2010 3:08 AM
  • Hi, I have removed all unsupported features that were in the file.  The problem is that it seems to be very inconsistent.  For example, I now have 2 excel files which are exactly the same and I can view one but not the other.  Has anybody else found this problem?
    Thursday, June 24, 2010 12:25 AM
  • you can view the other one. did you get any error inforamtion or same error?

    additionally, when you can't view the document, at the same check the event view or ULS logs.

    any error information might be helpful to throubleshoot.

    Thursday, June 24, 2010 2:48 AM
  • Hi,

    Microsoft support are currently looking into it but I have included the following info from the log file if you still wanted to look into it.  Thanks for your reply.

    06/24/2010 14:59:39.23     w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      6k38    Medium      ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server=http://stirling:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=(null), state id=0     
    06/24/2010 14:59:39.26     w3wp.exe (0x11EC)                           0x135C    Excel Services                    Excel Calculation Services        766u    Medium      ExcelService.LogRequest: starting request of type OpenWorkbook     
    06/24/2010 14:59:39.26     w3wp.exe (0x11EC)                           0x135C    Excel Services                    Excel Services Session            5pbu    Medium      SessionManager.BeginRequest: There are 1 active users     
    06/24/2010 14:59:39.26     w3wp.exe (0x11EC)                           0x135C    Excel Services                    Excel Services Session            1sxs    Medium      SessionManager.BeginRequest: Created Session id=23.201FbNacCUyNT1HwNDPTPXs90.5.en-US5.en-US73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-0060, caller=fe80::541:925:eed1:675c%11     
    06/24/2010 14:59:39.30     w3wp.exe (0x11EC)                           0x109C    Excel Services                    Excel Services Cache              1swc    Medium      BaseWorkbook.LoadWorkbookJob: Asking cache for workbook file http://stirling/Docs/Documents/Template 2 test5.xlsx.    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.30     w3wp.exe (0x11EC)                           0x109C    Excel Services                    Excel Services Cache              1swd    Medium      BaseWorkbook.LoadWorkbookJob: Loading BaseWorkbook from disk - starting from file C:\Windows\TEMP\Excel Server\FileCache\SharedServices1-942760090\43220ce4-6540-4b13-a1eb-b47ce8f495f0.xlsx.xlserver.    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.30     w3wp.exe (0x11EC)                           0x135C    Excel Services                    Excel Calculation Services        5pam    Medium      BaseWorkbookManager.BeginGetBaseWorkbookAndMarkUsed: There are 7 Base Workbooks in the Base Workbook Manager    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.30     w3wp.exe (0x11EC)                           0x135C    Excel Services                    Excel Services Cache              27e7    Medium      BaseWorkbookManager.BeginGetBaseWorkbookAndMarkUsed: Spawning BaseWorkbook job to load the file.    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.31     w3wp.exe (0x11EC)                           0x109C    Excel Services                    Excel Calculation Services        5p8t    Medium      Loading unsupported feature 7, already reported count 0.    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.34     w3wp.exe (0x11EC)                           0x109C    Excel Services                    Excel Calculation Services        5p8t    Medium      Loading unsupported feature 7, already reported count 0.    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.41     w3wp.exe (0x11EC)                           0x109C    Excel Services                    Excel Calculation Services        8trf    Medium      BaseWorkbookManager.UnsafeRemoveWorkbook: There are 6 Base Workbooks in the Base Workbook Manager    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      6k3f    Medium      ExcelServerProxy.ProcessSoapException: A SOAP exception during ExecuteWebMethod has occurred for server: http://stirling:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, method: OpenWorkbook, ex: System.Web.Services.Protocols.SoapException: Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap+EcsSoapException: The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:  Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.PostProcessRequest(Com...     
    06/24/2010 14:59:39.42*    w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      6k3f    Medium      ...mandResult result, WebMethodType webMethodType, Exception ex, Boolean endRequest, String sessionId)    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.ExecuteAsyncEndWebMethod(AsyncEndWebMethod method, IAsyncResult asyncResult, WebMethodType webMethodType)    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.EndOpenWorkbook(IAsyncResult asyncResult, String& workbookId, Boolean& hasOpenItemPermission)     at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)     at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServiceSoap.OpenWorkb...     
    06/24/2010 14:59:39.42*    w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      6k3f    Medium      ...ook(String url, CommandParameter parameter, CultureCommandParameter cultureParameter, Guid requestSiteId, String& workbookId, Boolean& hasOpenItemPermission)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.<>c__DisplayClass1.<OpenWorkbook>b__0(CommandParameter parameterDelegate, ExcelServiceSoap excelService)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWithSecurityContext(Boolean revertToSelf, CoreWebMethod coreWebMethod, ExcelServiceSoap excelService, CommandParameter parameter)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWebMethod(WebMethodType webMethodType, PreProcessWebMethod preProcessWebMethod, CoreWebMethod coreWebMethod, Boolean& noServerResponse).     
    06/24/2010 14:59:39.42     w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      3skc    Information    There was problem processing a request on Excel Calculation Services http://stirling:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap+EcsSoapException: The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:  Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.PostProcessRequest(CommandResult result, WebMethodType webMethodType, Exception ex, Boolean endRequest, String sessionI...     
    06/24/2010 14:59:39.42*    w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Services Web Front End      3skc    Information    ...d)    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.ExecuteAsyncEndWebMethod(AsyncEndWebMethod method, IAsyncResult asyncResult, WebMethodType webMethodType)    at Microsoft.Office.Excel.Server.Calcula     
    06/24/2010 14:59:39.42     w3wp.exe (0x0CE0)                           0x0988    Excel Services                    Excel Web Access                  5cbj    Medium      InternalEwr.RenderWebPart: Finished rendering internal EWR     
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        6soe    Medium      Heap of type 1 dtor called. Total allocations: 2892    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Services Session            2yez    Medium      Session.ContinueWithOpenUserWorkbook failed. Request Id is 230. Exception: Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:    Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects     at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.EndGetBaseWorkbookAndMarkUsed(IAsyncResult asyncResult, Boolean& openItemPermission)     at Microsoft.Office.Excel.Server.CalculationServer.Session.ContinueWithOpenUserWorkbook(IAsyncResult baseWorkbookResult, Ses...    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42*    w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Services Session            2yez    Medium      ...sionAsyncResult sessionResult)    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        3sll    Medium      ExcelService.PostProcessRequest: web method: OpenWorkbook, got exception Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:    Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects     at Microsoft.Office.Excel.Server.CalculationServer.AsyncPhaseBase.End(IAsyncResult result)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.<>c__DisplayClass4.<EndOpenWorkbook>b__3(IAsyncResult asyncResultForDelegate)     at Microsoft.Office.Excel.Server.Calculat...    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42*    w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        3sll    Medium      ...ionServer.ExcelServiceSoap.ExecuteAsyncEndWebMethod(AsyncEndWebMethod method, IAsyncResult asyncResult, WebMethodType webMethodType)    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        5cb1    Warning     Failed to load 'http://stirling/Docs/Documents/Template 2 test5.xlsx' with error: 'The workbook contains features that are not supported by Excel Services.   Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects'. [Session: 23.201FbNacCUyNT1HwNDPTPXs90.5.en-US5.en-US73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-0060 User: ENGINEROOM\Administrator]    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        4qc1    Medium      ExcelService.PostProcessRequest: Excel Server Recoverable Exception: Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:    Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects     at Microsoft.Office.Excel.Server.CalculationServer.AsyncPhaseBase.End(IAsyncResult result)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.<>c__DisplayClass4.<EndOpenWorkbook>b__3(IAsyncResult asyncResultForDelegate)     at Microsoft.Office.Excel.Server.CalculationS...    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42*    w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        4qc1    Medium      ...erver.ExcelServiceSoap.ExecuteAsyncEndWebMethod(AsyncEndWebMethod method, IAsyncResult asyncResult, WebMethodType webMethodType)    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        8trr    Information    Session closed workbook . [Session: 23.201FbNacCUyNT1HwNDPTPXs90.5.en-US5.en-US73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-0060 User: ENGINEROOM\Administrator]    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:39.42     w3wp.exe (0x11EC)                           0x112C    Excel Services                    Excel Calculation Services        5cag    Medium      ExcelService.PostProcessRequest: finished request of type OpenWorkbook    00000101-9852-7d16-0000-000050f7b00b
    06/24/2010 14:59:42.62     OWSTIMER.EXE (0x0620)                       0x08A8    SharePoint Portal Server          SSO                               8inc    Medium      In SSOService::Synch(), sso database conn string:      

    Thursday, June 24, 2010 5:15 AM
  • So the file you are trying to open is http://stirling/Docs/Documents/Template 2 test5.xlsx

    What version of office is on the system?

    http://sharepointnoob.wordpress.com/2009/10/29/unable-to-load-workbook-moss-2007/

     

     

    Wednesday, June 30, 2010 2:13 PM
  • Hi Jim, 

    We are running Office 2007.  I have had microsoft support onto it and they found there was a picture in the header.  The picture couldn't be seen in the excel file when viewing the header and was only removed after removing headers and footers in the 'preparing the document for distribution' function.  This has solved the problem.

     

    Cheers

    • Marked as answer by kimboss Wednesday, June 30, 2010 11:43 PM
    Wednesday, June 30, 2010 11:43 PM