Page 87 - Excel 2013 All-in-One For Dummies

Add-In Mania 69
1. Click the File menu button, click Excel Options or press Alt+FT to
open the Excel Options dialog box, and then click the Add-Ins tab.
The Add-Ins tab lists all the names, locations, and types of the add-ins to which you have access.
2. (Optional) In the Manage drop-down list box at the bottom, Excel Add- Ins is selected by default. If you want to activate one or more of your COM add-ins, select COM Add-Ins from the Manage drop-down list.
3. Select the Go button.
If Excel Add-Ins was selected in the Manage drop-down list box, Excel opens the Add-Ins dialog box (similar to the one shown in Figure 2-13), showing all the names of the built-in add-in programs you can load. If COM Add-Ins was selected, the COM Add-Ins dialog box appears instead.
4. Click the check boxes for each add-in program that you want loaded in the Add-Ins or COM Add-Ins dialog box.
Click the name of the add-in in the Add-Ins Available list box to display a brief description of its function at the bottom of this dialog box.
5. Click the OK button to close the Add-Ins or COM Add-Ins dialog box.
Figure 2-13:
Activating built-in add-ins in the Add-Ins dialog box.
When you first install Excel 2013, the program automatically loads all four add-ins (Analysis ToolPak, Analysis ToolPak - VBA, Euro Currency Tools, and Solver Add-In) displayed in the Add-Ins Available list box. (For more about these add-ins, see the following section, “Managing Excel add-ins.”) The tools in the two Analysis ToolPaks are added as special functions to the Function Library group and the Euro Currency tools to a Solutions group on the Formulas tab. The Solver add-in appears in the Analysis group on the Data tab.
Book I Chapter 2
Customizing Excel 2013