Unanswered Workbook could not be opened

  • 2011年7月5日 9:10
     
     

    Hi,

    We get an error 'Workbook could not be opened' when tryinmg to open it in PowerPivot.

     

    Errologging from ULS:

    07/05/2011 10:30:28.67  w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     2023 Information Failed to load 'http://gevpws05/PowerPivot%20Gallery/KundArtikel_statistik.xlsx' with error: 'Unable to open workbook due to unexpected exception: Microsoft.Office.Excel.Server.Host.HostFileException ---> System.Runtime.InteropServices.COMException (0x800703FA): Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa.     at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPSite.GetSPRequest()     at Microsoft.SharePoint.SPSite.get_Req... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     2023 Information ...uest()     at Microsoft.SharePoint.SPSite.SetAllowUnsafeUpdates(Boolean allowUnsafeUpdates)     at Microsoft.Office.Excel.Server.MossHost.SharePointHelperMethods.GetSite(String fileLocation, IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     --- End of inner exception stack trace ---     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2()     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsure... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     2023 Information ...ClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.TryExecuteWithUserContext(IIdentity userIdentity, Action`1 method)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.Init(Uri uri, Guid requestSiteId, IIdentity currentIdentity, Int64& fileSize, String& versionId, String& clientWorkbookUri, String& workbookFileName, String& privacyUri, String& termsUri)     at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId).'. [Session: 1.V22.96p+G1hc+dEMsj07rmBGw990.5.en-US5.en-US73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-006036.5f661d98-9a4d-4129-b0ff-6e72cf1649451.N User: 0#.w|geveko\_xlawarvi] 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67  w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     ech8 Medium   ExcelService.PostProcessRequest: Excel Server Recoverable Exception: Id=GenericFileOpenError; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: The workbook cannot be opened. ---> Microsoft.Office.Excel.Server.Host.HostFileException ---> System.Runtime.InteropServices.COMException (0x800703FA): Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa.     at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPSite.GetSPRe... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     ech8 Medium   ...quest()     at Microsoft.SharePoint.SPSite.get_Request()     at Microsoft.SharePoint.SPSite.SetAllowUnsafeUpdates(Boolean allowUnsafeUpdates)     at Microsoft.Office.Excel.Server.MossHost.SharePointHelperMethods.GetSite(String fileLocation, IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     --- End of inner exception stack trace ---     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2()     at Microsoft.Office.Exce... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     ech8 Medium   ...l.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.TryExecuteWithUserContext(IIdentity userIdentity, Action`1 method)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.Init(Uri uri, Guid requestSiteId, IIdentity currentIdentity, Int64& fileSize, String& versionId, String& clientWorkbookUri, String& workbookFileName, String& privacyUri, String& termsUri)     at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId)     --- End of inner exception stack trace ---     at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId)     at Microsoft.... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     ech8 Medium   ...Office.Excel.Server.CalculationServer.FileLoader.CreateFromTrustedLocationAndInit(Uri uri, TrustedLocation trustedLocationSettings, Guid requestSiteId)     at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.GetBaseWorkbookAndMarkUsedAsync(AsyncHandler`1 callback, Object userState, Request request, Uri uri, Boolean newWorkbook, Boolean useCollection, Boolean loadedOnDemand)     at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand)     at Microsoft.Office.Excel.Server.CalculationServer.Operations.OpenWorkbookOperation.StartExecution()     at Microsoft.Office.Excel.Server.CalculationServer.Operations.Operation.RunOperationAsync()     at Microsoft.Office.Excel... 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67* w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     ech8 Medium   ....Server.CalculationServer.Operations.OperationSite.PrepareComplete(PrepareAsyncArgs args) 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67  w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     nlfa Medium   SessionSite.CloseWorkbook: Called. SessionId: 1.V22.96p+G1hc+dEMsj07rmBGw990.5.en-US5.en-US73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-006036.5f661d98-9a4d-4129-b0ff-6e72cf1649451.N, CollabUserId= 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67  w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     nlcg Medium   Session.SetUnresponsive: Called. Session is 1.V22.96p+G1hc+dEMsj07rmBGw990.5.en-US5.en-US73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-006036.5f661d98-9a4d-4129-b0ff-6e72cf1649451.N 270b3993-1cad-4674-92d6-c05cd1524dc9
    07/05/2011 10:30:28.67  w3wp.exe (0x1468)                        0x14BC Excel Services Application     Excel Calculation Services     eci4 Medium   ExcelService.PostProcessRequest: finished request of type OpenWorkbook 270b3993-1cad-4674-92d6-c05cd1524dc9

    Any ideas

     

    Larra

     


    Larra

全部回复

  • 2012年3月28日 16:49
     
     

    Hi,

    I have the same error. Have you find the solution ?

    Regards

    • 已建议为答案 Thai Ly 2012年3月28日 17:16
    • 取消建议作为答案 Thai Ly 2012年3月28日 17:16
    •  
  • 2012年3月28日 17:20
     
     

    Hi,

    i have in uls this message :

    1. “The data culture ‘X’ was requested, and it is not fully supported because its language pack is not installed. Some features will not be available.

    I found with google these article :

    http://sharepoint-comments.com/2011/09/01/the-workbook-you-requested-cannot-be-opened-in-the-browser/

    http://www.kowalski.ms/2008/07/04/excel-services-was-unable-to-load-the-workbook-that-you-requested/

    but in ma case :

    my language is en, it's my MOSS installed version.

    I just launch assistant. it's solved my issues.

  • 2012年10月3日 15:09
     
     
    Did you get this resolved?

    RickLowe