1. Home
  2. Excel Plugin
  3. Sentieo Excel Plugin Installation guide and Troubleshooting
  1. Home
  2. Microsoft Office Plugins
  3. Sentieo Excel Plugin Installation guide and Troubleshooting
  1. Home
  2. Troubleshooting
  3. Sentieo Excel Plugin Installation guide and Troubleshooting

Sentieo Excel Plugin Installation guide and Troubleshooting

You will find here a guide to download and install Sentieo Excel Plugin and easy steps to overcome common difficulties on some systems…

Installation

  1. Please check that you are on Windows with Excel 2010 or newer.

    Neither Macs or Excel versions older than Excel 2010 are supported at this time.

  2. Close Excel
  3. Click here to download the installer.
  4. Double click on SentieoExcelAddIn

After opening Excel, select the word SENTIEO on the ribbon.

Click Login to Sentieo and enter your Sentieo credentials.

You will then see the tools available through our bespoke plugin.


Troubleshooting Sentieo Excel Plugin

There may be instances where the user is seeing this window during the installation.

Windows Project blue warning screen

You may see the below screen on rare occasions when you try to install Sentieo Office or Excel plugins

This screen is called “SmartScreen” and is part of Windows’ security features; It shows when you try to install a software for which Microsoft has not collected a lot of statistics from users’ computers of successful installations despite the warning message.

Sentieo certifies its software with Microsoft, but it sometimes needs to change instead of just renew its existing certificates. When we do this, the successful installation counter of SmartScreen resets to zero to our users start to see again the blue screen for a short while.

You can safely ignore the warning and click on Run Anyway to proceed with the installation.

If the security processes are more strict in your organization, you may need to discuss this with you IT personnel or you may not even see the Run Anyway button.

If you have the IT Admin authority, you can disable and enable the ability to override SmartSreen block by following the below steps: 

  1. Type Windows Security in windows search.
  2. Go to App & browser control
  3. Select the Warn option
  4. Now the Run Anyway button will appear
  5. Once the Plugin is installed then he can move back to Block.

Installation fails with error 0x80070659

If the installation of the Sentieo Excel Plugin fails with the error message below, the Windows profile configuration is preventing installation softwares like ours from adding new apps and addins to the system.

Windows is not set up by default to behave like this, except in rare cases such as some types of virtualized desktops offered by Amazon web services. If you are part of a wider organisation with an IT admin team, it could be that your windows profile was altered by the admin teams on purpose to block software installations.

The following steps show how to remove the bar. However, please be aware that this may violate your organization’s IT Policies, so we strongly suggest that you reach out for your IT admin’s assistance and only perform these steps under their supervision.

Steps for registry changes

  1. Download the CreateInitialRegistry.exe file from the below link.
    https://sentieoprofile.s3.amazonaws.com/CreateInitialRegistry.exe
  2. Save the file to any location.
  3. Run it.
  4. 2 files will be created in the same location
    1. DisableMsi.reg
    2. RevertDisableMsi.reg.
  5. Run DisableMsi.reg.
  6. Click on Yes on all the Message Boxes that appear.
  7. You should get the confirmation of a successful registry change (below). if not please contact Sentieo support.

  8. Now run the Sentieo Excel plugin installer again, and PLEASE REMEMBER to run RevertDisableMsi.reg after the installation is complete to revert your computer settings back to their original state.

Technical details about the registry change

The registry key DisableMsi controls if users can install software using Microsoft’s Windows Installer software installation tools; Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer

Our tool above creates a back up of the current value for DisableMSI (RevertDisableMsi.reg). We then ask the user to run DisableMSI.Reg file, which will set the value of the key to 0 (basically: disable the disablemsi setting). Then the user should run RevertDisableMsi.reg to return DisableMsi to its original state.

For further details on Microsoft Windows Installer and DisableMsi, please visit the below https://docs.microsoft.com/en-us/windows/desktop/msi/disablemsi

After Installing the new plugin, Sentieo is missing from the Ribbon

After a successful installation, if the plugin is missing from the ribbon, please go into the COM Add-ins menu (FILE -> Options -> Addins dropdown at the bottom look for com-addin, then go)

you will normally find a Sentieo Add-in entry. if you see this error message, please uninstall the plugin and proceed with a manual installation with your customer success representative.

Install Excel plugin manually

The Installer could fail for various reasons (missing MS .NET software framework, pending Windows Update, confusion Windows Registry entries due to multiple MS Office installations, restrictive Firewall rules, etc..).

This tutorial explains how to manually install the excel plugin.

  1. Download the core Sentieo Excel plugin components here. Open the zip file; it contains a folder called “SentieoExcelAddin”.
  2. Type Windows+R to access the run menu, type %appdata% and hit Enter

  3. Drag and drop the “SentieoExcelAddin” folder from the zip file to the Appdata folder which just opened when you hit Enter.
  4. Learn which version of Office you are running by following the instructions here
  5. Go to FILE -> Options -> Addins (while leaving Excel Add-in selected), and press go
  6. The following window will pop up. Press browse
  7. In the new window, enter in the top address bar%appdata%\SentieoExcelAddIn  , and select the most recent “SentieoUdfs-AddIn[..]” which is designed for the version of Excel in use.
    • if the Excel running is 32bit, select  “SentieoUdfs-AddIn-packed_[..]”;
    • if the Excel running is 64bit, then select  “SentieoUdfs-AddIn64-packed_[..]”;

You should be all set. If when loading the Excel plugin a small badge appears on the Update and Maintenance button, a new update is available, press the button and follow the instruction to download it.

Force update Sentieo Excel Plugin

  1. Make sure Sentieo Excel plugin is loaded (SENTIEO appears in the ribbon)
  2. Press the following keys simultaneously ‘Ctrl + Shift + Alt + U’
    This should open the following popup

  3. Click “Yes”
    The latest Sentieo Excel plugin will download in the background.
  4. Once the ‘Please Wait’ window closes, close all Excel files.
    Check that Excel.exe is not present anymore in the Details section of the task manager

  5. Restart Excel, the plugin should be updated.

I get an error message: “the file format and extension of […] open it anyway”

This occurs when the wrong bitness version of the excel plugin has been registered.

  1. Then press “No”.
  2. Follow the instructions above to register the Excel Plugin manually. At step 4, make sure to select the right version of the Excel plugin; If you are unsure about if you are running Excel 32bit or Excel 64bit, please follow this guide

I only get one button in the top ribbon called “please contact support”

This error usually means a configuration file used by the plugin has become corrupted. You need to clear it manually to reset the plugin and restart fresh.

  1. Close Excel
  2. Type run in the windows search to open the Run app (or use the shortcut Windows Key + R)
  3. Type ‘appdata’ and press OK
  4. Go into Local/Microsoft_Corporation
  5. Delete the folder ‘FullTrustSandbox(ExcelDN_Path_tkrehcb3zj0cqoyjgeeoo0qtmbgbwh0x’
  6. Restart Excel

If the folder Microsoft_Corporation folder is not present in the %appdata%/Local folder, search for ‘FullTrustSandbox’ inside the Local Folder, wherever it is present just delete it and restart excel.

How to uninstall an older version of the plugin?

Windows 10 and Windows 8

  1. Right click at the bottom left of the screen on the windows icon, then select the top option called Apps and Features or Programs and Features

  2. Look for Sentieo Excel Plugin in the list of software presented. Select it and press Uninstall
  3. Follow the on-screen instructions and accept if asked to run the program under administrative privilege.

Windows 7

  1. Click on the windows icon and type “uninstall a program” then select the first option in the “Control Panel” section
  2. Look for the Sentieo Excel Plugin, Select it and press Uninstall

  3. Follow the on-screen instructions and accept if asked to run the program under administrative privilege.
Updated on September 17, 2020

Was this article helpful?

Related Articles