How to load the Ablebits add-in in Office 365 installed from Microsoft Store

When you install the Ablebits product and the following informational message pops up once the installation process is complete, you may not see the Ablebits tabs in the Ribbon after starting Excel and the add-in will hardly appear in the list of COM Add-ins.
The message is shown after completing the installation

The issue happens due to specificities of the Office version installed from Microsoft Store which is run from the sandbox with its own data registry. If you use such a version of Office on your machine, the add-in can't be loaded automatically. In this case please take the steps below to manually add the Ablebits program into Excel.

Detect the bit version of Microsoft Office (32-bit or 64-bit)

  1. Launch Excel and open a blank workbook.
  2. Click File in the top left corner, and then select Account from the menu on the left.
  3. Click About Excel in the Product Information section:
    How to find the Office details

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:
Detect the bit version of Office

Manually load the add-in in Excel

  1. Click File in the Excel Ribbon again and go to Options.
  2. Choose Add-ins on the left side of the Excel Options dialog window.
  3. Select "COM Add-ins" from the Manage drop-down list at the bottom of the window and click Go:
    Open the COM Add-ins dialog from the Manage menu
  4. If the Ablebits add-in is not listed in the COM Add-ins dialog box, click Add and locate the add-in:
    Click the Add button to manually load the COM add-in
  5. Browse to the add-in's installation folder. By default, it should be as follows:

    C:\Users\USER_NAME\AppData\Roaming\Ablebits\Ultimate Suite for Microsoft Excel
    Open the folder where the add-in is installed

    Note. If you can't find the AppData folder, it may be hidden. To make it visible, please go to Control Panel -> Folder Options, switch to the View tab, select the "Show hidden files, folders, and drives" option and click OK.
  6. Find and select adxloader.dll for 32-bit Excel or adxloader64.dll if you run 64-bit Excel:
    Find the adxloader file corresponding to the bit version of Excel
  7. Click OK.

If the add-in is successfully added, you'll see it in the list of COM Add-ins as well as in the Excel Ribbon:
Ablebits is shown in COM Add-ins

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.

See also:

3 Responses to "How to load the Ablebits add-in in Office 365 installed from Microsoft Store"

  1. Jason Burton says:

    FYI - Im on Office 365 64 Office Insider build 16.0.10211.20004 and it says runtime error. When I reinstall the 2 tabs show up in excel but are blank.

    • Josiah Thomas says:

      I'm having the same problem. Adding the tools to the quick access toolbar makes them show up and they work, but the ribbon tabs are blank/empty.

      • Hello, guys,

        Thank you for reporting about this problem. Your feedback is highly appreciated and makes our team constantly update and improve the product.

        The point is that you are using the Insider version of Microsoft Office that is initially a beta version. Unfortunately, we are unable to support each Insider build because Microsoft publishes them once or twice a week. Currently we synchronize all our updates with those Office versions that are available in the Monthly and Semi-annual update channels.

        However, our developers have already fixed the issue you reported and by now the updated version of Ultimate Suite is available for download on our website.

        Sorry for any inconvenience that might be caused to you by this.

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite 2018.3 Summer Offer