You enable Excel add-ins through File > Options > Add-ins for desktop add-ins, or through Home > Add-ins for Microsoft 365 task pane add-ins.
An add-in that doesn’t show in the ribbon is usually just a checkbox away, but the wrong dropdown selection under Manage sends people in circles. How to enable add-ins in Excel depends entirely on the type — desktop add-ins, COM add-ins, and Microsoft 365 task pane add-ins each follow a different path. This guide covers all three routes, plus what to do when an add-in stays stubbornly disabled or the organization blocks it entirely.
Desktop Excel Add-Ins — The Standard Enable Path
Workbook add-ins, analysis tools like Solver and Analysis ToolPak, and XLL-based add-ins all use the same straightforward path. Open Excel and click File > Options > Add-ins. At the bottom of the window, look for the Manage dropdown — it defaults to Office Add-ins. Switch it to Excel Add-ins and click Go.
In the Add-Ins Available list, check the box next to the add-in you want and click OK. If the add-in doesn’t appear in the list, click Browse, locate the add-in file (typically a .xlam or .xll file), and confirm. When it’s done, the add-in loads into Excel and its features appear in the ribbon or become available in the background.
COM Add-Ins — A Different Dropdown, Same Menu
COM add-ins install separately from Excel files and show up in a dedicated list inside the same add-ins menu. Go to File > Options > Add-ins. In the Manage dropdown, select COM Add-ins and click Go. The dialog lists all registered COM add-ins on your system — check the box for the one you need and click OK.
This path only works in the desktop app; COM add-ins do not run in Excel for the web or in the Mac version under the same menu. If the add-in is grayed out in the list, it may already be loaded or it may be incompatible with your Excel version.
Microsoft 365 Task Pane Add-Ins — The Ribbon Route
Modern Office add-ins that appear as a floating task pane — things like Wikipedia, Bing Maps, or third-party productivity tools — use a different entry point. On the Home tab (or Insert tab in some versions), click Add-ins. From the dropdown, choose More Add-ins to open the Office Store, browse or search for the add-in, and select Add to install it.
To reopen an add-in you already installed, go back to Home > Add-ins and select My Add-ins. If it doesn’t appear, click Refresh. You can also upload a custom add-in file from your device using Manage My Add-in > Upload.
Enabling Add-Ins in Excel: The Three Types Compared
| Add-In Type | Enable Path | Key Details |
|---|---|---|
| Excel Add-ins (.xlam, .xll) | File > Options > Add-ins > Manage: Excel Add-ins > Go | Includes Solver, Analysis ToolPak, custom workbook add-ins |
| COM Add-ins | File > Options > Add-ins > Manage: COM Add-ins > Go | Third-party installed plugins; desktop app only |
| Task Pane Add-ins (M365 / Office Store) | Home > Add-ins > More Add-ins | Requires Microsoft account; works in desktop and web |
| Automation Add-ins | Same as Excel Add-ins path | Used in VBA automation; removal requires registry edit |
| Disabled Add-ins | File > Options > Add-ins > Manage: Disabled Items > Go | Re-enable from this dropdown, then restart Excel |
| Admin-deployed Add-ins | Installed centrally; appear under My Add-ins | Only your Microsoft 365 admin can deploy or remove |
| Store / Marketplace Add-ins | File > Get Add-ins or Home > Add-ins > More Add-ins | Blockable by tenant policy in the admin center |
What If An Add-In Is Disabled?
Microsoft disables add-ins that crash repeatedly or fail to load. The fix lives in a separate list most users miss. Open File > Options > Add-ins. At the bottom, open the Manage dropdown, select Disabled Items, and click Go. If the add-in appears there, select it and click Enable. Close Excel completely and reopen it — the add-in should now load normally.
Why Can’t I Install Add-Ins From The Store?
If the Get Add-ins button is grayed out or the Office Store won’t load, the cause is usually an organizational policy. Microsoft 365 admins control store access under Settings > Org settings > User owned apps and services in the Microsoft 365 admin center. The default setting allows store access, but if your admin cleared Let users access the Office Store, you cannot install or launch add-ins from the marketplace.
When an admin has deployed specific add-ins to your tenant, those appear under My Add-ins automatically. If a needed add-in is blocked, only your admin can change that — local settings can’t override the tenant policy.
Troubleshooting Quick Reference
| Symptom | Most Likely Cause | What To Check |
|---|---|---|
| Add-in not in the available list | Wrong Manage dropdown selected | Switch between Excel Add-ins, COM Add-ins, and Disabled Items |
| “Disabled” message on startup | Excel marked it as unstable | Check Disabled Items under Manage, enable, restart Excel |
| Store button is grayed out | Org policy blocks marketplace | Contact your Microsoft 365 admin |
| Add-in loads but nothing appears | Task pane may be hidden | Go to Home > Add-ins > My Add-ins and reopen it |
| Unsigned add-in won’t activate | Trust Center blocks unsigned code | Check File > Options > Trust Center > Trust Center Settings > Add-ins |
| “Your organization has disabled add-ins” | Admin-wide policy is enforced | Only the Microsoft 365 admin can change this |
Finish With The Right Add-In Active
When every method above is accounted for, the workflow narrows to a decision: desktop add-ins and COM add-ins live under File > Options > Add-ins with the correct Manage dropdown, while task pane add-ins live on the Home tab. If an add-in was once running but stopped appearing, the Disabled Items list is the first place to check — it’s the most common overlooked step. For organization-managed devices, tenant policy controls everything, and the admin center is the only door.
References & Sources
- Microsoft Support. “Add or remove add-ins in Excel.” Covers the full File > Options > Add-ins workflow for desktop, COM, and disabled add-ins.
- Microsoft Support. “View, manage, and install add-ins for Excel, PowerPoint, and Word.” Documents the Home > Add-ins path for task pane add-ins.
- Microsoft Learn. “Manage Add-ins in the Microsoft 365 Admin Center.” Explains tenant-level policies that block or allow add-in installation.