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:

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 for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard