No ratings

RPA has detected an issue that is preventing Excel Support

Topic

If get this error, it means you need to run as an administrator and let it repair the registry.

 

MRepetti_0-1625240379801.png

 

User needs to have local admin settings in the User group for read, write and modify.

 

Instructions

Option 1:

Once you close RPA and run as Admin, you will get this similar message. Click OK, it will make the repair.

 

MRepetti_1-1625240575284.png

 

Once this has been done the repair will run automatically on behalf of the user. 

 

____________________________________________________________________________________________

 

Also, go to Foxtrot Administrator > Data settings > select the following items.

  • Use Microsoft Office Automation for enhanced Excel Import
  • Use this DSN to open Microsoft Access file

 

MRepetti_0-1626442941871.png

 

 

Click 'Save Changes' button 

MRepetti_1-1626442941997.png

 

Close Foxtrot RPA (if applicable) and reopen

 

Option 2:

Verify that the registry key below exists:

 

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\WOW6432Node\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win32.

 

There will be one of two paths in this key Default value. If it is the old one you will want to replace it with the new path.

 

Old: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\WOW6432Node\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win32\: "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL"

 

New: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\WOW6432Node\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win32\: "C:\Program Files (x86)\Microsoft Office\Root\VFS\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\MSO.DLL"

 

This also may be an issue with allowing ActiveX through DCOM. The following article will assist in the configuration:

 

https://stackoverflow.com/questions/1847444/asp-net-cannot-create-activex-component

__________________________________________________________________________________________

 

Steps to check Microsoft Access Database Engine:

 

When upgrading to Nintex Foxtrot RPA v15.1.10 from Nintex Foxtrot RPA v15.1.2 or earlier, uninstall Microsoft Access database engine 2010.

Otherwise:

  • Nintex Foxtrot RPA fails to ‘Open Data’ of type accdb and Access 2000 mdb.
  • Data import of CSV and Excel files fail.

The installation for Nintex Foxtrot RPA v15.1.10 automatically installs Microsoft Access database engine 2016.

Important:  If you installed Nintex Foxtrot RPA v15.1.10 before uninstalling Microsoft Access database engine 2010, do the following:

  1. Uninstall Microsoft Access database engine 2010.
  2. Uninstall Microsoft Access database engine 2016.
  3. Re-install Microsoft Access database engine 2016 using this link:
    https://www.microsoft.com/en-us/download/details.aspx?id=54920.
    AccessDatabaseEngine.exe – 32 bit.

 

Additional Information

This repair is regarding registry key changes that were made in the newest release of Microsoft Office suite. Our developers had to account for the changes so this message was introduced to let users know a repair is needed and how the repair can be done on their behalf. Once the repair is done this should not be an ongoing issue.

 

Please verify that you do have the correct Access Database Engine installed which we utilize for data import. To do so navigate to Programs and Features. We currently use Microsoft Access database engine 2016 with version 15.1.10 so want to make sure the 2010 version isn't installed as well.

 

Related Links

In case the above self repair fails, please see this article:

RPA has Detected an Issue that is Preventing Excel Support

 

Additional Error Code related to Excel:

Error importing data from Excel

 

 

 

Labels: (1)
Version history
Last update:
‎07-21-2021 08:11 AM
Updated by:
Contributors