What are Excel Add-Ins?
Excel 2007 has a number of tools and features that are not loaded as part of the original installation of the program. These tools, called add-ins, are optional components that serve very detailed purposes, and many casual users of Excel will never have use for these items. However, if and when you do want to use one of these add-ins, you can load it into Excel with just a few easy steps. Once you’ve loaded an add-in, it will continue to be accessible in Excel unless you physically remove or disable it.
How to Load Add-Ins
Step 1: Click the Office button and then click Excel Options. (Click any image for a larger view.)
Step 2: In the Excel Options window that appears on your screen, click on Add-Ins from the list of categories in the left panel.
Step 3: In the drop down box next to Manage, select Excel Add-Ins. Click the Go button to continue.
Step 4: Put a check in the box next to the add-in you wish to load, and click OK.
At this point, you may see a dialog box stating that Excel can’t run the add-in because it’s not installed. Click Yes to install the add-in.
Wait for the installation of the add-in to complete. While Excel is processing this addition, a status window will appear on your screen showing the progress. When the installation stage is complete, you’ll be returned to your Excel workbook and the new add-in will be ready for use.
How to Remove an Add-In
If you ever need to remove an add-in that has been previously installed, you can do so in much the same way that it was added in the first place.
Follow Step 1 through Step 3 as described above. When you get to Step 4, uncheck the box next to the add-in that you wish to remove and then click OK. Removing an add-in is much quicker than the initial installation of one, but Excel may still take a moment or two to process the request. After this is done, the add-in will no longer be accessible (unless, of course, you load it again).
If you’re looking for more tips and tricks, browse through the library of Microsoft Excel user guides available here at Bright Hub, including our collection of chart and graph tutorials. Also, learn how to publish an Excel workbook as a web page, how to add hyperlinks to cells, how to use conditional formatting, and more.