Forum Discussion

David91's avatar
David91
Frequent Contributor
8 years ago

Unable to retrieve the worksheet list from the specified workbook. - ERROR load Excel

Hi i have problem with load Excel in TestComplete. When i open data excel file pop up dialog with error. ..Unable to retrieve the worksheet list from the specified workbook.... (on picture)

 Please help me... :(

  • David91's avatar
    David91
    8 years ago

    Solution. You must uninstall Windows Update:

     

    Windows7/2008              - KB4041681, KB4041678
    Windows 10                       - KB4041676
    Windows 2012                  - KB4041693, KB4041687

     

    or:

     

    1. Find prior version (4.0.9801.0) of msexcl40.dll.
    2. Place in another directory. They suggest the application directory, but since in the next step you will modify registry to point to this older version, it can probably go anywhere.
    3. Update registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel\win32 to point to the location from step 2.
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

    What happens if you try opening that workbook from outside of TestComplete?  Any dialogs come up?

    • David91's avatar
      David91
      Frequent Contributor
      No, ONLY via testcomlete. Yesterday was ok vůz today...pop Up error :(
      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor

        Translate the dialog for me... there's verbage there that I don't understand.  That might shed some light as to what's going on.

         

        Also... what changed... it was working fine yesterday, not today... something changed.