Whenever you install an add-in in Excel, it is added to an internal list of available add-ins. This list is used by Excel whenever you display the Add-ins dialog box. (The Add-ins dialog box is where you are shown available add-ins and can use a check box to indicate which should be enabled when running Excel.) Removing a previously installed add-in so that it doesn't appear in the Add-ins dialog box can be a confusing process, since Excel provides no way to directly edit that internal list of add-ins. You can get around this frustration, however, by following these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2733) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Removing Add-ins.
Leave your own comment:
Comments for this tip:
John 14 Sep 2016, 12:01
this doesn't remove the add-in commmand from the custom toolbar, for instance we had to upgrade an add-in for Kareo PMS. There is an add-in for excel 2010 windows 7, and a diff add-in for 2010 on windows 8/10. when we upgraded all our pc's to 10 the add-in stopped working so we removed it. Then installed the new Kareo add-in for windows 10, but when we go to run the add-in it still wants to go out an look for the previous one and completely ignores the one we just installed. It's like the custom tool bar won't update and stays stuck on the add-in that no longer exist. quite annoying an only way to fix is completely remove excel and reinstall it.
Stephen Clothier 01 Jul 2016, 08:09
The problem I have happens when I upgrade from Office 2013 to 2016. I reference an Add In pointing to an xlam file.
After upgrade this is only seen if I manually open it before opening a referring workbook. Otherwise the functions in the AddIn are not found. Has a default option been reset so that the worksheet does not see the functions if the Add In is not already open?
SayedRakib 04 Apr 2016, 18:35
Vijay 18 Feb 2016, 04:25
I am not able remove the old add-in from excel 2016 for MAC. Even if I deleted the add-in from the specified path and removed from the Add-in list, it is always showing the add-in when I reopen the exce.
Dedo 13 Nov 2015, 12:47
The Add-in I want to remove does not appear in the Add-in list of ad-in Manager. So it is presumably an automaticaly loaded Add-in.
I was following yours instruction up to the Point 5(Windows 7 professional, Excel 2003). Excel reports that it cannot find the Add-in file, but it is not a question, just an announcement. The message appears each time I open Excel. Is there any remedy to it?
Joe 28 Aug 2015, 12:28
Ok. I got rid of the error notice by deleting the old add-in without enabling the replacement. Then restarting Excel and enabling the replacement.
Joe 28 Aug 2015, 12:20
I'm having same results as Lewis. Starting Excel I get pop-up "Sorry, we couldn't find C:\Program Files (x86)\..." Go to Add-Ins management and delete it from list. Restart Excel and repeat the problem.
Lewis 03 Jun 2015, 21:17
I followed the steps above but it didn't work...the add-in was in my D drive but this D drive crashed and excel somehow locks this location of the add-in and even after I chose to remove it from list, everytime I re-open excel, it will pop the message that excel could not found the .xla file in D drive..
Ian 10 May 2015, 20:34
I had developed an add-in containing user defined functions for a small department in my office. These functions were then added to formulas in some Excel workbooks shared within the department. Unfortunately I did not control where the users saved the add-in, and it was typically saved in a different location for each user. Whenever a shared spreadsheet was opened by someone with a different path for the add-in, all formulas containing the user defined function would convert the function reference to a fully qualified path, creating an external link to a file that could not be found.
Try as I might, I could not point Excel to a standard path for the add-in, it would not "let go" of the original path set by the user. This tip fixes that problem, very much appreciated thank you!
KCribb 24 Sep 2014, 08:48
This suggestion is exactly what I've been looking for! Thanks for sharing!
Ray 18 Jun 2014, 02:19
Worked well, thank you.