Problems removing an Excel Add-in

Introduction

As you probably know by now, I offer a number of tools for your daily Excel work:

Sometimes you decide you no longer need an add in and delete the file from your system. But now, every time you launch Excel, it starts to complain:

Erro messages due to deleted add-in file

Very irritating, as this message pops up every single time you launch Excel.

Trying to solve this (the wrong way)

So let's open the add-ins dialog: File, Options, Add-ins tab, click that "Go..." button to access this dialog:

The add-ins dialog

Now try to click on that add-in (in blue in this screen-shot). Excel asks you if you want it removed:

Excel offering to delete your unwanted add-in

Hey, this is great! Let's click Yes. This is what the add-ins dialog looks like after doing so:

The add-ins dialog after the removal

Look! The addin has left the building! But wait. Close the dialog, close Excel and restart Excel. This is what happens:

Erro messages due to deleted add-in file

Grrrrrr. Excel apparently hasn't really removed the add-in from its list.

Solving the problem

So let's open the add-ins dialog: File, Options, Add-ins tab, click that "Go..." button to access the add-ins dialog once more:

The add-ins dialog

See? The add-in is still there!

Now try to click on that add-in (in blue in this screen-shot). Excel asks you if you want it removed:

Excel offering to delete your unwanted add-in

Here's the deal: click No.

Next, uncheck the box next to the add-ins name:

Uncheck the add-in

Again, Excel asks you to remove the add-in:

Excel offering to delete your unwanted add-in

Click No

Click the Close button on the add-ins dialog. Excel pops up a familiar message:

Erro messages due to deleted add-in file

Ignore the message and shut down Excel and open it again. The irritating error message should be gone, but we're not there yet. Open the add-ins dialog. Click on the name of the add-in. Excel asks again:

Excel offering to delete your unwanted add-in

This time, click Yes.

DONE!


Comments

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].