-->
Click Add-Ins, and then in the Manage box, select Excel Add-ins. In the Add-Ins available box, select the Solver Add-in check box, and then click OK. Notes: If the Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in. “Free” add-in for Excel 2010 and 2013 for Windows. Built-in feature for Excel 2016 for Windows (Office 365 Subscription). Click here to learn where to find it. Power Query is not yet available for the Mac versions of Excel. This page will help you determine if you have the right version of Excel, and provide installation instructions.
To see how your add-in will run in Office on iOS, you can sideload your add-in's manifest onto an iPad using iTunes, or sideload your add-in's manifest directly in Office on Mac. This action won't enable you to set breakpoints and debug your add-in's code while it's running, but you can see how it behaves and verify that the UI is usable and rendering appropriately.
Prerequisites for Office on iOS
- A Windows or Mac computer with iTunes installed.ImportantIf you're running macOS Catalina, iTunes is no longer available so you should follow the instructions in the section Sideload an add-in on Excel or Word on iPad using macOS Catalina later in this article.
- An iPad running iOS 8.2 or later with Excel or Word installed, and a sync cable.
- The manifest .xml file for the add-in you want to test.
Office 365 Allow Add Ins
Prerequisites for Office on Mac
- A Mac running OS X v10.10 'Yosemite' or later with Office on Mac installed.
- Word on Mac version 15.18 (160109).
- Excel on Mac version 15.19 (160206).
- PowerPoint on Mac version 15.24 (160614)
- The manifest .xml file for the add-in you want to test.
Sideload an add-in on Excel or Word on iPad using iTunes
Block Add Ins Office 365
- Use a sync cable to connect your iPad to your computer. If you're connecting the iPad to your computer for the first time, you'll be prompted with Trust This Computer?. Choose Trust to continue.
- In iTunes, choose the iPad icon below the menu bar.
- Under Settings on the left side of iTunes, choose Apps.
- On the right side of iTunes, scroll down to File Sharing, and then choose Excel or Word in the Add-ins column.
- At the bottom of the Excel or Word Documents column, choose Add File, and then select the manifest .xml file of the add-in you want to sideload.
- Open the Excel or Word app on your iPad. If the Excel or Word app is already running, choose the Home button, and then close and restart the app.
- Open a document.
- Choose Add-ins on the Insert tab. (On the Insert tab, you may need to scroll horizontally until you see the Add-ins button.) Your sideloaded add-in is available to insert under the Developer heading in the Add-ins UI.
Sideload an add-in on Excel or Word on iPad using macOS Catalina
Important
With the introduction of macOS Catalina, Apple discontinued iTunes on Mac and integrated functionality required to sideload apps into Finder.
- Use a sync cable to connect your iPad to your computer. If you're connecting the iPad to your computer for the first time, you'll be prompted with Trust This Computer?. Choose Trust to continue. You may also be asked if this is a new iPad or if you're restoring one.
- In Finder, under Locations, choose the iPad icon below the menu bar.
- On the top of the Finder window, click on Files, and then locate Excel or Word.
- From a different Finder window, drag and drop the manifest.xml file of the add-in you want to side load onto the Excel or Word file in the first Finder window.
- Open the Excel or Word app on your iPad. If the Excel or Word app is already running, choose the Home button, and then close and restart the app.
- Open a document.
- Choose Add-ins on the Insert tab. (On the Insert tab, you may need to scroll horizontally until you see the Add-ins button.) Your sideloaded add-in is available to insert under the Developer heading in the Add-ins UI.
Sideload an add-in in Office on Mac
Note
To sideload an Outlook add-in on Mac, see Sideload Outlook add-ins for testing.
- Open Terminal and go to one of the following folders where you'll save your add-in's manifest file. If the
wef
folder doesn't exist on your computer, create it.- For Word:
/Users/<username>/Library/Containers/com.microsoft.Word/Data/Documents/wef
- For Excel:
/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents/wef
- For PowerPoint:
/Users/<username>/Library/Containers/com.microsoft.Powerpoint/Data/Documents/wef
- For Word:
- Open the folder in Finder using the command
open .
(including the period or dot). Copy your add-in's manifest file to this folder. - Open Word, and then open a document. Restart Word if it's already running.
- In Word, choose Insert > Add-ins > My Add-ins (drop-down menu), and then choose your add-in.ImportantSideloaded add-ins will not show up in the My Add-ins dialog box. They are only visible within the drop-down menu (small down-arrow to the right of My Add-ins on the Insert tab). Sideloaded add-ins are listed under the Developer Add-ins heading in this menu.
- Verify that your add-in is displayed in Word.
Remove a sideloaded add-in
You can remove a previously sideloaded add-in by clearing the Office cache on your computer. Details on how to clear the cache for each platform and application can be found in the article Clear the Office cache.
See also
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:
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.
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)
- Start Excel and open a blank workbook.
- Click the File tab in the top left corner and select Account from the menu on the left.
- Click About Excel in the Product Information section:
- 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:
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
- Click File in the ribbon again and go to Options.
- Choose Add-ins on the left side of the Excel Options dialog window:
- Open the Manage drop-down list, select COM Add-ins, and click Go:
- If the Ablebits add-in is not listed in the COM Add-ins dialog box, click the Add button on the right side:
- 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)AblebitsUltimate Suite for Microsoft Excel - If you installed the Business edition and picked the Just me option, the installation folder is
%LOCALAPPDATA%AblebitsUltimate 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: - If you installed the Personal, Terminal Server, or Business edition for Everyone, the installation folder is
- Find and select:
- adxloader.dll for 32-bit Excel
- adxloader64.dll if you run 64-bit Excel
Click Open. - The Ablebits add-in has been added to the COM Add-ins list. Click OK:
Now the add-in should appear 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 [email protected]. Our support service assistants will do their best to help you solve the problem.
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 [email protected]. Our support service assistants will do their best to help you solve the problem.