How to Make an Inactive Add in Active in Excel
By 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.
Step 1
Click the Microsoft office button at the top left, and then click the "Excel Options" button.
Step 2
Select "Add-ins" from the Excel Options window.
Step 3
Verify that "Excel Add-ins" is selected in the Manage drop-down list and click "Go."
Step 4
Select the check box that corresponds with the add-in you need and click "OK."
Step 5
Follow the onscreen instructions to install the add-in.
References
- "Excel for Accountants, 2nd edition"; Conrad Carlberg; February 2011
Writer Bio
Based in Southern California, Kristy Borowik has been writing professionally since 2004. She serves as a technical writer and editor, earning several awards from the Society for Technical Communication, with articles also appearing in "Trilogy Life" magazine. Borowik holds a Bachelor of Arts in English and print journalism from Southern Adventist University.