Error message on opening Excel after deleting add-in file

[Prof Wonmug]

I have two add-in files (AddinA.xlam & AddinB.xlam). I decided to
consolidate them into one file with several different modules. So, I
moved all of the modules in AddinB to AddinA and deleted AddinB.xlam.

Now, every time I open Excel, even with a new workbook, I get this
error message:

'C:\Documents and Settings\Administrator\Application Data
\Microsoft\AddIns\AddinB.xlam' could not be found. ...

I have searched all of the relevant workbooks, none of which are open
when I get the error message, and cannot find the string "AddinB"
anywhere.

How do I get rid of this error message?

 

[Peter T]

Do you have a reference to the old addin, Tools References, or some other
Link perhaps.

Regards,
Peter T

 

[Prof Wonmug]

Do you have a reference to the old addin, Tools References, or some other
Link perhaps.

Well, if I do, I can't find it. Where do I look? All searches for the
string "AddinB" say "not found".

 

[Gord Dibben]

Are you asked if you want to delete it?

Is AddinB still still checked in Tools>Add-ins?

Uncheck it and answer Yes.


Gord Dibben MS Excel MVP

 

[Prof Wonmug]

Are you asked if you want to delete it?
Nope

Is AddinB still still checked in Tools>Add-ins?

Uncheck it and answer Yes.

Thnak you. That did it. Problem solved.

This is Excel 2007, so there's no Tools option. I tried the Add-In tab
on the magical ribbon, but no joy. I guess that was too logical.

Next, I tried File | Options | Add-Ins. At the top, under Active
Add-Ins, AddinB was still listed. Of course, there is no check box to
uncheck and no Delete option. That would be too easy. Then I noticed
the Manage: box with Excel Add-ins and clicked Go. Finally, there is a
list with checkboxes to uncheck. Uncheck the box and away it goes.

Thanks for the tip.

I wonder if the Microsoft developers get extra credit for making
things arcanel If so, the Excel developers must all be billionaires.

 

[Gord Dibben]

Apologies for not directing you to the Add-ins manager in 2007.

But happy to hear you're fixed up.


Gord

 

[Prof Wonmug]

Apologies for not directing you to the Add-ins manager in 2007.

But happy to hear you're fixed up.

Well, how could you know? I forgot to mention that I was using 2007.

Again, thanks for the tip.