How to Make an Inactive Add in Active in Excelby Kristy Borowik
When you install Microsoft Excel, you have a choice to also install some of Excel's add-ins, such as the Solver tool. These add-ins are stored in Excel but are not available from the menus until you activate them. Before trying to locate your installation disc, try activating the add-in you need through the Excel Options screen. If the add-in does not show in the Manage drop-down list, you will need your Excel installation disc and can easily install the add-ins you need by following the on-screen instructions.
Click the Microsoft office button at the top left, and then click the "Excel Options" button.
Select "Add-ins" from the Excel Options window.
Verify that "Excel Add-ins" is selected in the Manage drop-down list and click "Go."
Select the check box that corresponds with the add-in you need and click "OK."
Follow the onscreen instructions to install the add-in.
Items you will need
- Excel installation disc
- Ablestock.com/AbleStock.com/Getty Images