We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

David91's avatar
David91
Frequent Contributor
9 years ago
Solved

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
    9 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.
AlexKaras's avatar
AlexKaras
Community Hero
9 years ago

Hi,

 

> Microsoft Access Database Engine 2010 Redistributable x64 i have installed, office 2013, windows 7. TestComplete i have version 11

 

Unless I got it wrong... TestComplete 11 is 32-bit application and thus Microsoft Access Database Engine *must* be 32-bit as well. Office bitness does not matter in this case.

 

 

David91's avatar
David91
Frequent Contributor
9 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.