ElyxAI

How to Add Add-ins in Excel

To add add-ins in Excel, open Insert, Get Add-ins (the button may say Add-ins), pick the add-in, and click Add. For a built-in add-in such as the Analysis ToolPak or Solver, use File, Options, Add-ins, set Manage to Excel Add-ins, click Go, check the box, and click OK.

ThomasCoget
12 min
Non classé
How to Add Add-ins in Excel

Add an add-in from the store

Open the Insert tab and choose Get Add-ins. In Microsoft 365 the button is often labeled Add-ins, and Get Add-ins is inside that menu. Search or pick an add-in, then click Add. Excel installs it for your account and adds its button to the ribbon.

If Get Add-ins is missing, the store may be turned off for your organization, or the Microsoft 365 build is old. An admin has to allow Office add-ins. Signing out and back in also refreshes the list after an add-in was shared with you.

Turn on a built-in Excel add-in

The Analysis ToolPak and Solver are not in the store. Go to File, Options, Add-ins. At the bottom, set Manage to Excel Add-ins and click Go. Check Analysis ToolPak or Solver, then OK. Both then appear on the Data tab.

COM Add-ins are a different list in that same Manage box. Use it for an add-in your company installed on the computer, not for a store add-in. If an add-in failed to load, look under Manage, Disabled Items, select it, and click Enable.

If the add-in does not appear

Close every Excel window and open the file again. A store add-in follows the Microsoft account, so a different account will not show it. A built-in add-in that is unchecked under Excel Add-ins is installed but off: check the box again.

Direct answers

How do you add add-ins in Excel?

Insert, Get Add-ins, choose the add-in, Add. That installs an Office add-in from the store. Built-in add-ins use File, Options, Add-ins instead.

How do I get add-ins in Excel?

Insert, Get Add-ins opens the store. Search, then Add. If Get Add-ins is missing, update Microsoft 365 or ask an admin: the store can be turned off for the organization.

How do you add the Analysis ToolPak or Solver?

File, Options, Add-ins. Manage: Excel Add-ins, Go. Check Analysis ToolPak or Solver, then OK. They show up on the Data tab. They are not in Get Add-ins.

Where are Excel add-ins turned on or off?

File, Options, Add-ins. Excel Add-ins lists Analysis ToolPak and Solver. COM Add-ins is a separate list in the same Manage box. Disabled Items is where Excel parks an add-in that failed to load.

Elyx is an Excel add-in. Add it from Insert, Get Add-ins. 7-day trial, no card.

Start the 7-day trial