How to remove xla from xls without renaming or deleting xla file?

Question

I need to get rid of an XLA (excel add-in) from a spreadsheet, but everything on the web seems to point to renaming/deleting the xla file.

This is not an option as the xla file is used by many other spreadsheets and is on a shared drive.

Are there any other alternatives?

Answer 1

Do you mean you want to remove it from the add-in dialog box? Disconnect from the shared drive, load Excel, and try to install the add-in. Excel will tell you it can't find it and ask if you want to remove it. Once you've removed it, reconnect to the shared drive.

Answer 2

If I understand your question, the solution might be:

1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available box, clear the check box next to the add-in you want to unload, and then click OK.

Source: http://office.microsoft.com/en-us/excel/HP052037321033.aspx

Answer 3

I copied all the classes and modules (drag and drop) from the xla to the 'local' project.

Save and close xls

I searched for the xla project name in the registry (with excel closed) and deleted the value.

Open excel

Done