No Ablebits tabs in Excel ribbon

Or the tabs are there, but when you click on them — nothing happens

Suppose you've just installed Ultimate Suite or even have been using it for a while, and one day you start Excel and can't see any Ablebits tabs in the ribbon or you click on the tabs, but tools do not start. Most often the problem is caused by Office or Windows updates that were not properly tested for compatibility issues. On this page, find the instructions on how to make Ablebits tabs show up in your Excel ribbon or become clickable again.

Important! As we are unable to detect when your Windows or Office versions are updated, before taking the steps below, please restart your machine.
Note. If you can see the Ablebits tabs in the ribbon, but when you click on them — nothing happens, jump right to Solution 4 & Solution 5 to fix this.

Solution 1. Enable Ultimate Suite

First of all, let's check if Ultimate Suite is disabled and if yes, enable it.

Step 1. Check if the add-in is disabled

  1. Click the Microsoft Office button in Excel 2007 or the File tab in Excel 2010-2019.
  2. Go to Excel Options -> Add-ins:
    View the add-ins.
  3. Click the Manage drop-down list, select Disabled Items, and click Go:
    Disabled items.
  4. If the add-in is in the list, select it and click the Enable button.
  5. Restart Excel & enable the add-in in COM Add-ins.

Step 2. Enable the add-in in the COM Add-ins dialog box

  1. Click the Microsoft Office button in Excel 2007 or the File tab in Excel 2010-2019.
  2. Go to Excel Options -> Add-ins:
  3. Click the Manage drop-down list, select COM Add-ins, and click Go:
    Click COM Add-ins.
  4. Find the add-in in the list:
    Find the add-ins in the list.
  5. If the add-in is unchecked, check it and click the OK button in the COM Add-ins dialog window.
  6. If the add-in is checked, uncheck it and click OK. Then open the dialog window again and check the add-in item. The tab should appear in the ribbon.

If there is no Ablebits in Disabled Items (in Office installed from Store)

If you use Office installed from Microsoft Store and there is no Ablebits in Disabled Items or you have enabled it but nothing happened, take the following steps:

  1. Update Office.
  2. Uninstall Ultimate Suite.
  3. Check the COM Add-ins dialog box:
    COM Add-ins.
    And if you can see Ablebits in the list, remove it by clicking the Remove button:
    Remove Ablebits from COM Add-ins.
  4. Go to the Download page and get the latest version of the Ultimate Suite edition you use. Install it on your machine.

Solution 2. Load Ultimate Suite manually

If you cannot see the add-in in the Disabled list or in the COM Add-ins dialog box, let's load it manually. Please follow the instructions.

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.

Solution 3. In Office from Microsoft Store, reinstall the add-in

It may happen that you can neither enable the add-in nor load it manually. Also, your Office version may be installed from Microsoft Store. In this case, you'll have to reinstall the add-in.

How to find out that Office is installed from Store

  1. Start Excel (or another Office application), open a black workbook.
  2. Click the File tab in the top left corner and select Account from the menu on the left.
  3. If your Office is installed from Store, it will be indicated in the About Excel section after the build number:
    How to find out that your Office is installed from Store.

If your Office version is not the one installed from Microsoft Store, jump right to Solution 4.

Tip. Actually, the Office version installed from Microsoft Store may be the cause of various issues, so the radical yet most efficient solution is to switch to Desktop Office version.

Uninstall Ultimate Suite via Control Panel

  1. Close all Microsoft Excel files.
  2. Go to Start and open Control Panel.
  3. Click on Programs:
    Pick Programs
  4. Pick the Uninstall a program option:
    Uninstall a program
  5. You will see a list of all installed programs. Find the add-in you want to uninstall and double-click it.
    Click Yes in the dialog window:
    Are you sure?

Install the latest update of Ultimate Suite

As soon as Ultimate Suite is uninstalled, please go to our Latest versions page, download and setup the edition of Ultimate Suite you use. After this, run Excel and check if Ablebits tabs have finally appeared in your ribbon. If you still can't see them, please continue reading and try the solutions below.

Solution 4. Use the .NET Framework Repair Tool

If the previous steps haven't helped and there are still no tabs in the ribbon, please try out the .NET Framework Repair Tool.

  1. Download .NET Framework Repair Tool: https://www.microsoft.com/en-us/download/details.aspx?id=30135
  2. Select the files to download and click Next:
    Select all files to download.
  3. Run the NetFxRepairTool.exe file, check the I have read and accept the license terms box, and click Next:
    Check the I have read and accept the license terms box.
  4. You will see changes the tool recommends making. Click Next to apply the changes:
    Recommended changes.
  5. When the changes are made, click Finish:
    Changes complete.
  6. Restart your machine, run Excel, and check if the Ablebits tabs have appeared in the ribbon. If you still can't see them, try to repair Microsoft Office.

Solution 5. Repair your Office

  1. If you use Windows 10, go to the Start menu and click Settings:
    In the Start menu, click Settings.

    Tip. If you use other than Windows 10 versions, go to the Repair an Office application page, select your version and follow the instructions.
  2. Open Apps & features:
    Open Apps & features.
  3. In the list, find the Microsoft Office application and click the Modify button:
    Click the Modify button.
  4. In the dialog window, select the Online Repair option and click Repair:
    Online Repair.
  5. Confirm your readiness by clicking Repair again:
    Ready to start.
  6. When the repair is complete, restart your computer. Then open Excel and check if the Ablebits tabs have shown up in the ribbon. If there are still no tabs, please try the last solution.

Solution 6. Update Office

An older version of Office may be the cause of the issue too. Please follow the update instructions and run Excel again. If there are still no Ablebits tabs, please contact us at support@ablebits.com

Update via your Office Account

The easiest way is to check updates via your Office account. Open an Excel file and go to File > Account. Under Product Information, click Update Options > Update Now:
Office updates.

But it may happen that you won't see this pane in your Office. In this case, you can tune updates via Windows Settings.

Update via Windows Update

  1. Go to Update & Security:
    Go to Update & Security.
  2. In Windows Update click on Advanced options:
    Advanced options.
  3. Turn on Give me updates for other Microsoft products when I update Windows:
    Give me updates for other Microsoft products when I update Windows.
  4. Go back to Windows Update and click the Check for updates button:
    Check for updates.

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.