No Ablebits tabs in Office 365 installed from Store

How to load Ultimate Suite for Excel manually

So, you've installed the Ablebits add-in, the setup is complete and... the following unpleasant message pops up:

Most probably, if you start Excel you won't see the Ablebits tabs in the ribbon and the add-in won't appear in the list of COM Add-ins.

The thing is that if you use the Office installed from Microsoft Store, each application including Excel is running in its own sandboxes that have their own state, registry and file system. All changes in the system registry and file system are synced in one direction, toward itself into the sandbox. From time to time somethings breaks in this synchronization, whereupon no add-ins are installed normally.

Please take the steps below to manually add the Ablebits program into Excel and finally get to work:

• Detect the bit version of Microsoft Office (32-bit or 64-bit)
• Manually load the add-in in Excel

1. Start Excel and open a blank workbook.
2. Click the File tab in the top left corner and select Account from the menu on the left.
3. Click About Excel in the Product Information section:
   
4. When the dialog box opens, you'll see the full version number and bit version (32- or 64-bit) of your Office at the top:
   
   Keep in mind your bit version, it is necessary to know it when you load the add-in manually.

1. Click File in the ribbon again and go to Options.
   

2. Choose Add-ins on the left side of the Excel Options dialog window:
   
3. Open the Manage drop-down list, select COM Add-ins, and click Go:
   
4. If the Ablebits add-in is not listed in the COM Add-ins dialog box, click the Add button on the right side:
   
5. Browse to the add-in's installation folder.
   • If you installed the Personal, Terminal Server, or Business edition for Everyone, the installation folder is
     C:\Program Files (x86)\Ablebits\Ultimate Suite for Microsoft Excel
   • If you installed the Business edition and picked the Just me option, the installation folder is
     %LOCALAPPDATA%\Ablebits\Ultimate Suite for Microsoft Excel
   Note. If you can't find the AppData folder, it may be hidden. To make it visible, go to File Explorer and check the Hidden Items box on the View tab:
   
6. Find and select:
   • adxloader.dll for 32-bit Excel
   • adxloader64.dll if you run 64-bit Excel

   
   Click Open.

7. The Ablebits add-in has been added to the COM Add-ins list. Click OK:
   

Now the add-in should appear in the ribbon:

If you have difficulties on any of the above steps or the instructions don't work for you, please leave your comment below or contact us at support@ablebits.com. Our support service assistants will do their best to help you solve the problem.