This article walks through re-enabling the Ablebits Add-in in Excel 2016.
Step-by-Step
If the Ablebits add-in is not showing up in the Excel UI you can follow the steps below to re-enable it..
1. First make sure the add-in isn't disabled
2. Click the Microsoft Office File menu in Excel 2016.
3. Go to Options -> Add-ins.
4. Under Disabled Application Add-ins navigate down to the Manage dropdown and select "COM Add-ins"
5. Click Go...:
6. If the add-in is in the list, select it and click the 'OK' button.
The Ablebits menu's should appear across the top to the right of your standard Excel menus
If the add-in keeps disappearing, follow the below steps to add it to The Trust Center
- In Excel, click on “File”.
- On the left-hand side, click on “Options”.
- The “Options” window opens. On the left-hand side, go to “Trust Center”.
- On the “Trust Center” page, click on “Trust Center Settings”.
- Again, a new window opens (“Trust Center”). Click on Trusted Locations.
- Click on Add new location
- Now, click on Browse in order to select the folder containing your add-in. (ex. C:\Users\f001mr0\AppData\Roaming\Ablebits\Ultimate Suite for Microsoft Excel\)
- In total you have to confirm 3 times by clicking on OK.
For Further Information