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:
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

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.