No Ablebits tabs in Office 365 installed from Store

How to load Ultimate Suite for Excel manually

Important! Before reading this post, please note that if you use Office installed from Microsoft Store, we strongly recommend you switch to the Office Desktop version by following the instructions on this page. Office from Store is full of surprises and in order to avoid other issues, it is better to install Office Desktop instead.

So, you've installed the Ablebits add-in, the setup is complete and... the following unpleasant message pops up:
The setup is complete and you can see this message.
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.

Tip. Not sure if you have the Office version installed from Store? Here is an easy way to find out.

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)

  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:
    How to find the Office details.
  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:
    Find out the bit version of Office.
    Keep in mind your bit version, it is necessary to know it when you load the add-in manually.

Manually load the add-in in Excel

  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:
    Click on the Add-ins section.
  3. Open the Manage drop-down list, select COM Add-ins, and click Go:
    Click COM Add-ins.
  4. If the Ablebits add-in is not listed in the COM Add-ins dialog box, click the Add button on the right side:
    Click the Add button.
  5. Browse to the add-in's installation folder.

    • If you installed the Personal, Terminal Server (obsolete), 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:
    Check the Hidden box.
  6. Find and select:

    • adxloader.dll for 32-bit Excel
    • adxloader64.dll if you run 64-bit Excel

    Select the adxloader for your bit Office version.
    Click Open.

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

    Now the add-in should appear in the ribbon:
    Ultimate Suite 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.