Topic 38: How to Install and Uninstall Excel Add-ins to Your System?

[seema]

Excel 2007 add-in is program that adds additional functionality or features to Excel. Installing add-ins gives you additional Excel features not available in the Ribbon by default.

Excel add-ins are use to store one or more custom worksheet functions. When the add-in is loaded, you can use the functions like any built-in worksheet function.

There are three different types of add-ins:

• Built-in add-ins available when you install Excel 2007
• Add-ins that you can download from Microsoft web site (http://www.office.microsoft.com)
• Add-ins developed by third-party vendors (must be purchased)

When you first install Excel 2007, the built-in add-in programs included with Excel are not loaded and therefore are not yet ready to use. The following are the steps to load the built-in add-in programs.

Similar Threads:

• Topic 20: Excel AND() Function
• Topic 14: How to Install, Remove and Get Free Excel Add-in ?
• A Perfectly Clean Uninstall

[seema]

To install an Excel 2007 add-in

• From the Office ****on, click the Excel Options ****on.
• From the Excel Options dialog box displayed, click Add-Ins in the left hand pane.
• 
  
  
• Select an add-in (such as Analysis ToolPak) under the Inactive Application Add-ins on the right-hand pane and click Go ****on (near the bottom of the screen).

[seema]

• From the Add-Ins dialog box displayed, you can access to several options.
• 
  
  
• Click to select one or more add-in (such as Analysis ToolPak).
• Click OK.
• From the pop-up dialog box, click Yes to install the add-in. It will takes some time to configures.

Note: Excel places the Data Analysis add-in on the Data tab, Analysis group. Some other add-ins will be places on the Add-Ins tab.

[seema]

To remove an add-in in Excel 2007

• From the Office ****on, click the Excel Options ****on.
• From the Excel Options dialog box displayed, click Add-Ins in the left hand pane.
• Select an add-in (such as Analysis ToolPak) under the Active Application Add-ins on the right-hand pane and click Go ****on.
• From the Add-Ins dialog box displayed, click to deselect the add-in you want to remove.
• Click OK. Excel removes the add-in.