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 ...
  • 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
8 years ago

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

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

      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.

      • David91's avatar
        David91
        Frequent Contributor
        8 years ago

        Dialog: Unable to retrieve the worksheet list from the specified workbook. The following error occurred: An unexpected error from an external database driver (1)..

         

        Iam today cant doing any change.. in my PC..