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, 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.
  8. 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.

Responses

Hi, I have it ticked at COM add on, however the tab is not appear in the ribbons.
Please help.

Thank you.

Reply

Hi Khairul,

Regarding this issue, we’ll reply to you by email.
Please check your Spam/Junk/Trash email folders if you don’t see the message in your Inbox.

Thank you.

Reply

Gone through all the steps...nothing in the ribbon....

Katerina Bespalaya says:
June 10, 2019 at 9:56 am

Hello Heather,

Sorry to hear that you're having difficulties with our add-in. We have just replied to your query by email. Please check your Inbox.

ryan McGowan says:
July 2, 2019 at 6:28 pm

It doesnt appear in the ribbon

Reply
Katerina Bespalaya says:
July 2, 2019 at 6:48 pm

Hello Ryan,

Please try out the solutions described on this page

If none of the solutions work for you, then please contact support@ablebits.com for further assistance.

Reply
Cogan Guillaume says:
September 18, 2019 at 11:41 am

hi,
i do not have the ablebits file in my excel....

Reply
Katerina Bespalaya says:
September 18, 2019 at 12:57 pm

Hello,

If you've installed our add-in and it hasn't appeared in your Excel Ribbon, please check the solutions described on this page.

If the issue you have is different, then please contact us by email (support@ablebits.com) and describe the problem in more detail. Thanks.

Reply
VORA MAYUR CHIMANBHAI says:
March 3, 2020 at 1:39 pm

NOT INSTOLING

Reply

Hello,

Thank you for contacting us. Could you please describe the problem you faced in more detail? Any screenshots illustrating the issue would also help. Thank you.

Reply

Hello im stuck at step 6
I have found adxloader.dll but doesnt give me an "open" option just "ok"

Reply
Katerina Bespalaya says:
March 19, 2020 at 2:27 pm

Hello Stephanie,

I am sorry to hear that you are having difficulties with our add-in. Please send us a screenshot of your File Explorer window with the Ultimate Suite for Microsoft Excel folder open and the adxloader.dll file selected to support@ablebits.com.

I should also tell you that the version of Office installed from Microsoft Store caused a lot of problems so Microsoft has stopped deploying that Office recently and now only the native desktop Office is available for end-users. That's why we can't guarantee that our add-in will work correctly in Office from Store. If you are using this version of Office, we strongly recommend you to switch to the desktop version. Here are the instructions on how to do this: https://www.ablebits.com/docs/microsoft-office-install-desktop/

Thank you.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

60+ professional tools for Excel
60+ professional tools for Excel
2019–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