Add-Ins Not Showing In Excel | Fix Missing Tabs Fast

You open Excel, and the button you rely on is gone. No tab. No panel. No clue. When add-ins not showing in excel hits, it usually comes down to one of three things: the add-in did not load, Excel disabled it after a crash, or a security setting stopped it.

This page walks you through a clean sequence that works on Windows and Mac. You’ll start with quick checks, then move into the spots where Excel hides add-ins: Disabled Items, COM Add-ins, Excel Add-ins, and the Office Add-ins list. You’ll also learn what to do after updates, account sign-out, or a new work laptop policy.

Why Add-Ins Disappear In Excel

Excel loads add-ins at startup. If something slows Excel down, triggers an error, or clashes with another add-in, Excel may switch the add-in off to protect the app from repeated crashes. It can feel random, but the pattern is consistent.

Here are the most common reasons you’ll see missing add-ins or a missing Add-ins tab:

• Excel Disabled The Add-In — A crash, hang, or slow load can push the add-in into the Disabled Items list.
• The Add-In Is Unchecked — The add-in exists, but it is not selected under Excel Add-ins or COM Add-ins.
• The Ribbon Is Hidden — The add-in is loaded, but the ribbon tab is collapsed or customized away.
• Sign-In Dropped — Store add-ins and some connected tools rely on your Microsoft account or work account sign-in.
• Trust Center Blocks It — Macro, XLL, or file-based add-ins can be blocked when the file came from the internet or a restricted folder.
• Policy Limits Add-Ins — In many workplaces, admin settings can block the Office Store, stop web add-ins, or allow only approved add-ins.

Add-Ins Not Showing In Excel After Update Or Crash

Updates and crashes often change what loads at startup. If add-ins not showing in excel began right after an Office update, a forced restart, or a workbook crash, start here. This section also helps when an add-in used to appear, then vanished without you changing settings.

Before you change deeper settings, do these two quick checks. They fix a surprising number of “missing” cases.

1. Restart Excel Fully — Close all Excel windows, wait ten seconds, then open Excel again. If Excel stayed running in the background, a full close resets the add-in load cycle.
2. Check Ribbon Display — If you use a collapsed ribbon, click the ribbon arrow or press Ctrl+F1 on Windows to expand it. On Mac, use the ribbon toggle at the top right of the window.

Re-Enable Disabled Items And Slow Add-Ins

When Excel thinks an add-in caused trouble, it can disable it silently. Your goal is to check Disabled Items first, then turn the add-in back on and restart Excel.

1. Open Excel Options — On Windows, select File, then Options.
2. Go To The Add-Ins List — In the left pane, choose Add-ins.
3. Open Disabled Items — At the bottom next to Manage, choose Disabled Items, then select Go.
4. Enable The Add-In — If you see your add-in, select it, then choose Enable.
5. Restart Excel — Close Excel and open it again to test the ribbon and buttons.

If the add-in returns and then disappears again later, Excel may still be detecting a crash or a slow load. That can happen when Excel starts with many workbooks, large templates, or other add-ins that load at the same time.

• Start Excel With No Files — Launch Excel first, then open your workbook after the add-in tab appears.
• Disable Extra Add-Ins — Turn off add-ins you don’t use, then test the one you need.
• Update The Add-In — Many add-ins ship fixes through their own updater or a newer build from the vendor.

Turn On COM Add-Ins And Excel Add-Ins

Some add-ins are present on your system but not checked. This is common after reinstalling Office, moving to a new PC, or switching between 32-bit and 64-bit Office. If your add-in is a COM add-in, it will not show in the Excel Add-ins list, and the reverse is also true.

Check COM Add-Ins

1. Open The Add-Ins Manager — File, Options, then Add-ins.
2. Select COM Add-Ins — At the bottom next to Manage, choose COM Add-ins, then select Go.
3. Tick The Box — Check the box next to the add-in you want to load, then select OK.
4. Restart Excel — Close and reopen Excel to confirm the tab appears.

Check Excel Add-Ins And XLAM Files

If your add-in is a file like .xlam, .xla, or .xll, it is usually managed under Excel Add-ins. Some workbook tools also place files in a shared add-ins folder and register them there.

1. Open Excel Add-Ins — File, Options, Add-ins, then set Manage to Excel Add-ins and select Go.
2. Select The Add-In — Tick the add-in in the list. If it is missing, choose Browse and select the add-in file.
3. Confirm The Startup Path — If you browse to a file stored on a network drive, test a local copy to rule out path or permission issues.
4. Restart And Test — Close Excel, reopen it, and check the ribbon again.

Restore The Add-Ins Tab On The Ribbon

If the add-in is enabled but you still don’t see a tab, the ribbon may be customized. Excel can hide whole tabs, including Developer and Add-ins, and a custom ribbon file can remove vendor tabs too.

1. Open Ribbon Settings — Go to File, Options, then Customize Ribbon.
2. Turn On Hidden Tabs — In the right list, tick Developer and Add-ins if they’re unchecked, then select OK.
3. Reset If Needed — If tabs look scrambled, select Reset, then choose Reset only selected Ribbon tab or Reset all customizations.

Fix Office Store Add-Ins And Account Issues

Office Store add-ins are different. They run as web add-ins and are linked to your Microsoft account or work account. If you’re signed out, offline, or blocked by an admin policy, the add-in list can look empty, or the “Get Add-ins” button can fail to load.

1. Check You’re Signed In — In Excel, open File and look for your account info. Sign in with the account that installed the add-in.
2. Open The Add-Ins Catalog — Select File, then Get Add-ins. On some builds you can also use Home, then Add-ins.
3. Use My Add-Ins — In the dialog, select My Add-ins to see what’s already installed. If the list looks stale, choose Refresh.
4. Re-Add The Tool — If the add-in is missing, search it in the store list and add it again.

If your workplace blocks the Office Store, you may see messages that the store isn’t available. In that case, you may still be able to load approved add-ins through a managed catalog. If you have an IT help desk, ask whether your tenant allows Office add-ins and whether your account is assigned access to the add-in you need.

Trust Center, File Blocks, And Mac Notes

Security settings can hide or stop add-ins without removing them. This is common with macro-enabled add-ins, XLL add-ins, and add-ins stored in folders Excel does not trust. If missing add-ins shows up only for certain files or only after downloading an add-in, this section is the one to work through.

Check Trusted Locations

If an add-in lives in a folder Excel treats as unsafe, Excel may refuse to load it. A clean fix is to store the add-in in a trusted folder and add that folder to Trusted Locations.

1. Open Trust Center — File, Options, then Trust Center, then Trust Center Settings.
2. Open Trusted Locations — Select Trusted Locations in the left list.
3. Add A Folder — Choose Add new location, then pick the folder where your add-in file sits.
4. Retest The Add-In — Close Excel and reopen it so Excel reloads the add-in from that location.

Unblock Downloaded Files

Windows can mark files from the internet as blocked. If your add-in file was emailed, downloaded, or extracted from a zip, it may carry a block flag that stops macros or add-ins from running.

• Check File Properties — Right-click the add-in file, open Properties, then look for an Unblock option. If you see it, check it, then apply.
• Extract Again If Needed — If you unzipped the add-in, unblock the zip first, then extract again to clear the mark from the contents.

Mac Differences

On Mac, you won’t see the same Trust Center screens. Store add-ins still depend on sign-in, and ribbon customization can still hide tabs. For file-based add-ins, keep the add-in file in a local folder you control, then add it through the Excel Add-ins dialog. If a Mac security prompt appears, allow Excel access to the file.

Repair Office And Prevent A Repeat

When none of the steps above bring the add-in back, the issue may be a broken Office install, a damaged add-in file, or a mismatch between Excel and the add-in’s build. Repairing Office is often faster than chasing one hidden setting, and it resets core components that add-ins depend on. On a shared PC, confirm you have permission to load add-ins and Excel isn’t running in restricted mode again.

1. Try Safe Mode — Hold Ctrl while launching Excel on Windows, or run Excel in safe mode to test whether an add-in conflict is blocking the ribbon. If the add-in shows in normal mode only sometimes, a conflict is likely.
2. Run An Office Repair — In Windows Settings, open Apps, find Microsoft 365 or Office, then choose Modify. Try Quick Repair first, then Online Repair if the issue stays.
3. Reinstall The Add-In — Remove the add-in from its manager, restart, then install it again from the vendor or store.
4. Keep One Clean Startup — Start Excel with no auto-open files, confirm the add-in loads, then re-enable other add-ins one at a time.

To reduce the chance of another surprise disappearance, keep these habits in place:

• Update Excel Regularly — Office updates often include add-in reliability fixes.
• Store Add-Ins In One Folder — A single local folder with stable permissions cuts down path errors.
• Avoid Double-Click Loading — If you open an .xlam by double-clicking, it may not stay registered. Add it through Excel’s Add-ins manager instead.
• Watch Crash Prompts — If Excel offers to disable slow add-ins, note which one it flags and update that add-in.

If you still see missing add-ins after repairs, note what kind of add-in it is and where it came from. That single detail will point you to the right manager screen, and it will also help the vendor troubleshoot faster.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback