How to Add and Disable Add-Ins for Your Excel Files

You can use add-ins in Excel to fulfill some complex task. And in this article, we will introduce how to add and disable add-ins in Excel.

If you need to use add-ins in Excel, you need to add and activate it into Excel. On the other hand, if you don’t need to use add-ins, you can also disable it. Here we will demonstrate the steps to add and disable add-ins in Excel.

Add Add-Ins

  1. Click “File” in the ribbon.
  2. And then click the button “Options”.Click File and Click Options
  3. In the “Excel Options” window, choose the option “Add-ins”.
  4. Next choose the type of add-ins in the “Manage” textbox. Here we choose the “Excel Add-ins” as an example”.Manage Add Ins
  5. Next click the button “Go” next to the “Manage”.
  6. And then the window of “Add-Ins” will pop up. In this window, check the option that you need. Here we check the “Analysis ToolPak” in the window. If you need to install other add-ins, you can click the button “Browse” to add it. Besides, some add-ins require running installation packages. You need to run it in your computer.

Check One Add-In

  1. After that, click the button “OK”.
  2. Now you can come back and check the result. The “Analysis ToolPak” will be added in the tab of “Data”. Thus, here click the tab “Data” in the ribbon. You can see that the add-in has already appeared in the toolbar.Add-in in toolbar

Therefore, whenever you need to use this tool, you can click the tab “Data” and select it.

Disable Add-Ins

Now if you don’t need to use the add-ins, you can also remove it from the toolbar.

  1. Click “File” in the ribbon.
  2. And then click the button “Options” to activate the “Excel Options” window.
  3. Here still choose the “Add-ins”.
  4. In the manage text box, choose the type of the add-in that you need to disable. Here we need to disable the “Analysis ToolPak”, therefore we choose the “Excel Add-Ins”.
  5. And then click the button “Go”.Choose Type
  6. In the “Add-Ins” window, uncheck the add-in that you don’t need.
  7. Next click the button “OK”.Uncheck Options
  8. Thus, this “Analysis ToolPak” will not appear in the toolbar.

Actually, this method only removes the Excel add-in from the ribbon. The add-in is still in your computer. If you need to delete the add-in from your computer, you need to uninstall the add-ins. Therefore, don’t mix these two different concepts.

In addition, as for removing the “Com Add-Ins”, things are different. You can select the add-in and then click the button “Remove”. And then you can remove it from your computer.

Remove Com Add-ins

Be Careful When Using Add-ins in Excel

Even if you can acquire a lot of convenience from add-ins, you still need to be careful. Some malicious hacker will develop add-ins that can steal your data and information. And even worse, your file will be damaged due to the abnormal add-ins. When such accident happens, you can use our repair tool to repair xls corruption and other errors in Excel. This tool is exactly the insurance for your file.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair doc damage and outlook repair software products. For more information visit

One response to “How to Add and Disable Add-Ins for Your Excel Files”

  1. Thanks for some other great article. The place else could anyone get that kind of info in such a perfect way of writing? I’ve a presentation next week, and I am on the search for such information.

Leave a Reply

Your email address will not be published. Required fields are marked *