MS Excel Add-in not installed

image i am also having the same error. please assist. microsoft excel 2016 MSO(16.0.4226.1001.

Thank you and looking forward to your response.

Uhuuuu … Happy that it worked in the end. I have to ask , did office install in it’s usual C:\Program Files\Office location or did it reinstall in the C:\Program Files\WindowsApps . Because if this is the case then I think the antivirus was to blame. We are using a power shell script to install it ( ok add some keys in the registries no funny business ) and this might have been flagged by the antivirus as malicious code.

Dragos.

Hello,

Since you have the same error , can you please go up a few posts and download our debugging guide , follow it and come back with the results :slight_smile: Also in this thread there are indications on what logs we need and preferably of what quality .

I would also check if Office is installed from the store and what happens it you disable the antivirus when you install the plugin :slight_smile:

Regards,
Dragos.

The install was to C:\Program Files\Microsoft Office. Interestingly, the path to the COM Add-ins in excel is now different - C:\Program Files\Microsoft Office (new installation path) instead of the previous C:\Program Files\WindowsApps (old installation path)

The AV software always notifies me if/when it blocks anything. But they were no notifications and no messages in the AV logs at the time of the issue. The revised paths may hold the key to the solution, but I’ll leave the detailed investigations to others far smarter in those matters than I. Just glad to be able to progress on the learning journey. Thanks again :slight_smile:

Thank you for being part of this learning journey. What made me think that the installation path could be a case was an article https://www.add-in-express.com/creating-addins-blog/2019/02/27/office-from-store-issues/ which highlighted the issues that they faced with the Store version of Excel.

So just to summarize what we discoverer in our investigation:

Excel installations that are based on the Microsoft Store will install Excel in the following path : C:\Program Files\WindowsApps – this would cause issues with the installation of the plugin.

The solution that worked is to reinstall Microsoft Office in the “traditional” location ( for example : C:\Program Files\Office) and then reinstall the Excel plug-in.

The alternative solution would be to try and regain control over the C:\Program Files\WindowsApps folder https://answers.microsoft.com/en-us/windows/forum/windows_rt-files/what-is-cprogram-fileswindows-apps-hidden-folder/783b5a18-c44d-46f7-b638-e98054b7c2a8 and then reinstall the plugin. I have to mention that this solution is not validated therefore I need a volunteer :smiley: So please the next guy / gal which is encountering this would you be willing to try the alternative solution and then come back with the results :slight_smile:

Regards,
Dragos.

In case this post gets flagged as the solution I would leave the debugging guide that we developed. Please note that it’s still rough around the edges so treat it as a final draft version, butt still draft :wink: UiPath Excel Addin Installation Troubleshooting v4.docx (388.6 KB)

Regarding logs, they are usually found in %localappdata%/UiPath/Logs and

  • Studio.log – gives us information on how the Studio started or if it was able to load all the correct libs.

  • Execution.log – gives us information on what happens after you click the run button

  • UiPath.ExcelAddIn.log – gives us information on how the plugin interacted with Excel ( will not be present if the Add-In failed to install )

  • ExcelAddIn_Install.log – gives us information on the issues encountered during the Excel plugin installation ( in this particular case it’s the most important )

Usually we would request that you delete the logs prior replicating the encountered defect. This is a best practice when reporting a defect since it would speed up the reading of the logs by the development team.

1 Like

This fix doesn’t work for me either. UiPath is in my trusted publisher, I’ve manually installed the addin from the path in the document but same problem persists.

Can you please share the logs :slight_smile:

Regards,
Dragos.

[5/8/2020 10:22:19 AM] ---------------start---------------
[5/8/2020 10:22:19 AM] Running script at 05/08/2020 10:22:19 on OQWY
[5/8/2020 10:22:19 AM] Trying to install the UiPath ExcelAddIn
[5/8/2020 10:22:19 AM] Studio base path is C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788
[5/8/2020 10:22:19 AM] RepairOnly mode is False
[5/8/2020 10:22:19 AM] Found VSTO registry key HKLM:\SOFTWARE\Microsoft\VSTO Runtime Setup\v4R
[5/8/2020 10:22:19 AM] VSTO runtime version is 10.0.60828
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName
[5/8/2020 10:22:19 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName with value UiPath.Integration.ExcelAddIn
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description
[5/8/2020 10:22:19 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description with value UiPath.Integration.ExcelAddIn
[5/8/2020 10:22:19 AM] UiPath ExcelAddIn path is C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.vsto
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest
[5/8/2020 10:22:19 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest with value file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.vsto|vstolocal
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior
[5/8/2020 10:22:19 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior with value 3
[5/8/2020 10:22:19 AM] Adding the add-in to the VSTO security inclusion list
[5/8/2020 10:22:19 AM] Checking inclusion key @{PublicKey=1r263ztFjvj/kzQSeLrWvPZnqsvm69NZrK3cppxf7NGtOWcUst43dR39ll6YsoXP4/rI24XMt0RDD/l5SqoVZ4ujnR3KCFscdsMLrpfyIEcnwKiXvyEdzWGYOOVCeMygg+LKtwWyRfVETzq4rc+1k71CcUpWTep69RUlbDLyN4+vBytnUvT9dwX6CyDLzvkC0073t47wV+/9JrpOXq4kwiUFl0017+SEikJ4Wni/wYsM+z60BPN95XJkf2NgI8kzKs7kXnofm2NEWPYRumanshZ/Ifb4E605L4pFd76SLUDSlT4nRofKw7CA0LJNnLJkDsS2MHPCO3LxhUhrEGlutQ==AQAB; Url=file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.vsto; PSPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\a80f09c2-3f4a-4e5b-9782-3fa7ead65935; PSParentPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion; PSChildName=a80f09c2-3f4a-4e5b-9782-3fa7ead65935; PSProvider=Microsoft.PowerShell.Core\Registry}
[5/8/2020 10:22:19 AM] Checking inclusion url file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.vsto
[5/8/2020 10:22:19 AM] Removing existing inclusion entry for this url
[5/8/2020 10:22:19 AM] Checking inclusion key @{PublicKey=1r263ztFjvj/kzQSeLrWvPZnqsvm69NZrK3cppxf7NGtOWcUst43dR39ll6YsoXP4/rI24XMt0RDD/l5SqoVZ4ujnR3KCFscdsMLrpfyIEcnwKiXvyEdzWGYOOVCeMygg+LKtwWyRfVETzq4rc+1k71CcUpWTep69RUlbDLyN4+vBytnUvT9dwX6CyDLzvkC0073t47wV+/9JrpOXq4kwiUFl0017+SEikJ4Wni/wYsM+z60BPN95XJkf2NgI8kzKs7kXnofm2NEWPYRumanshZ/Ifb4E605L4pFd76SLUDSlT4nRofKw7CA0LJNnLJkDsS2MHPCO3LxhUhrEGlutQ==AQAB; Url=file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1731\UiPath.Integration.ExcelAddIn.vsto; PSPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\e28e163e-9296-4aa7-b498-cbc58bfd4f6f; PSParentPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion; PSChildName=e28e163e-9296-4aa7-b498-cbc58bfd4f6f; PSProvider=Microsoft.PowerShell.Core\Registry}
[5/8/2020 10:22:19 AM] Checking inclusion url file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1731\UiPath.Integration.ExcelAddIn.vsto
[5/8/2020 10:22:19 AM] RSAKeyValue is 1r263ztFjvj/kzQSeLrWvPZnqsvm69NZrK3cppxf7NGtOWcUst43dR39ll6YsoXP4/rI24XMt0RDD/l5SqoVZ4ujnR3KCFscdsMLrpfyIEcnwKiXvyEdzWGYOOVCeMygg+LKtwWyRfVETzq4rc+1k71CcUpWTep69RUlbDLyN4+vBytnUvT9dwX6CyDLzvkC0073t47wV+/9JrpOXq4kwiUFl0017+SEikJ4Wni/wYsM+z60BPN95XJkf2NgI8kzKs7kXnofm2NEWPYRumanshZ/Ifb4E605L4pFd76SLUDSlT4nRofKw7CA0LJNnLJkDsS2MHPCO3LxhUhrEGlutQ==AQAB
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad PublicKey
[5/8/2020 10:22:19 AM] System.Management.Automation.PSArgumentException: Property PublicKey does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad.
[5/8/2020 10:22:19 AM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad PublicKey with value 1r263ztFjvj/kzQSeLrWvPZnqsvm69NZrK3cppxf7NGtOWcUst43dR39ll6YsoXP4/rI24XMt0RDD/l5SqoVZ4ujnR3KCFscdsMLrpfyIEcnwKiXvyEdzWGYOOVCeMygg+LKtwWyRfVETzq4rc+1k71CcUpWTep69RUlbDLyN4+vBytnUvT9dwX6CyDLzvkC0073t47wV+/9JrpOXq4kwiUFl0017+SEikJ4Wni/wYsM+z60BPN95XJkf2NgI8kzKs7kXnofm2NEWPYRumanshZ/Ifb4E605L4pFd76SLUDSlT4nRofKw7CA0LJNnLJkDsS2MHPCO3LxhUhrEGlutQ==AQAB
[5/8/2020 10:22:19 AM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad Url
[5/8/2020 10:22:19 AM] System.Management.Automation.PSArgumentException: Property Url does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad.
[5/8/2020 10:22:19 AM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5ed5e939-139e-4f3b-acaa-89e5af9c73ad Url with value file:///C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.vsto
[5/8/2020 10:22:19 AM] ImportSigningCertificate dllPath is C:\Users\HP\AppData\Local\UiPath\app-20.4.0-beta1788\UiPath.Integration.ExcelAddIn.dll
[5/8/2020 10:22:20 AM] ImportSigningCertificate Importing SignerCertificate into the CurrentUser TrustedPublisher store
[5/8/2020 10:22:20 AM] ImportSigningCertificate - SignerCertificate imported successfully
[5/8/2020 10:22:21 AM] StartExcelAndCheckAddInConnection - COMAddIns.Count: 2
[5/8/2020 10:22:21 AM] StartExcelAndCheckAddInConnection - ComAddIn detected: Microsoft Power Map for Excel
[5/8/2020 10:22:21 AM] StartExcelAndCheckAddInConnection - ComAddIn detected: Microsoft Power Pivot for Excel
[5/8/2020 10:22:21 AM] StartExcelAndCheckAddInConnection - UiPath ComAddIn not valid
[5/8/2020 10:22:21 AM] OfficeAddInSetup Error:
[5/8/2020 10:22:21 AM] Finished ExcelAddIn installation at 05/08/2020 10:22:21

Hello,

Can you please share with me a screenshot of your COM add-ins ?

image

Regards,
Dragos.

Well hello there you just volunteered for a little experiment :slight_smile: to be more precisely could you try and regain control of your C:\Program Files\WindowsApps folder https://answers.microsoft.com/en-us/windows/forum/windows_rt-files/what-is-cprogram-fileswindows-apps-hidden-folder/783b5a18-c44d-46f7-b638-e98054b7c2a8 and them try to reinstall the plug-in :slight_smile:

You other alternative would be to reinstall Excel and make sure that it installs in C:\Porgram Files\Office…

Regards,
Dragos.

1 Like

I’ve tried the first option and successfully regained control, but I don’t know what else should happen beyond that. Am I installing the plugin inside the WindowsApps folder? Cos I tried reinstalling the plugin and it says it’s already installed.

I’m not sure reinstalling Excel is an option I’m open to exploring at the moment.

Just to mention that this is the last week of the course and I’m still unable to get started.

Having Office installed in that folder means that some time ago you installed office via the store. Now that option is not available anymore. We learned that our addin is not playing well with the office installed from the store. So it would a be a good point to start from: reinstall office if it is possible, so it will be present in the default install location : program files.

Problem with reinstalling Excel is, I can’t find my Microsoft 365 pack. If I reinstall Excel now, how am I supposed to get the activation code?

Guys,

I had the the same problems as you all posted earlier, but then I realised that I had not installed Microsoft Office at all !
I’ve had the license all this time but never installed the Office pack into my laptop. I’ve bee using the Windows App version of Excel, Word, etc.

So, another solution might be,

  1. Open Office App in your PC
  2. Login to your account
  3. Select Install Office
  4. Wait until the installation is done
  5. Now, open StudioX and enable the Excel Add-in
  6. Go to the Excel Addins and check if the UiPath Excel Add-in is there in the Active ones ( for those of you who weren’t able to find it earlier, including me :slight_smile: )

Let me know if this works. Thanks.

2 Likes

Hi Original OP here …

Blockquote

a possible fix should be available on next week update

Blockquote

I’ve installed the latest version of Studio, but now there’s no longer an option to install the Excel add-in.

because you started in Sudio profile. Change profile from Settings to StudioX

Thanks, we’re making progress!

No matter what I change in Trust Settings in Excel I still get the following error
Excel add-in fail

Can you point me in the direction of exactly what Excel settings are required please?