Search code examples
excelvbaexcel-addinsxlwings

Can't fully remove xlwings addin from Excel

What I've done so far:

  1. removed xlwings Python module with pip uninstall xlwings
  2. deleted the .xlam file Excel was referenced
  3. unchecked the addin from "Excel Addins" inside Excel and it showed a message asking if I wanted to remove it because the original file was not found, so I clicked yes.

When I open Excel the xlwings.xlam file is not loaded now.

Problems:

  1. I still see the xlwings tab in the Ribbon. But when I see in File->Options->Customize Ribbon. I don't see any xlwings reference.

enter image description here

  1. in the Project section of the VBA editor I still see the xlwings.xlam addin

enter image description here

Solution

  • If you still have xlwings installed, you can run xlwings addin remove.

    If not and you installed the add-in by using xlwings addin install, it was placed in the XLSTART folder. To find out where that is, open the VBA editor via Alt-F11, then, in the Immediate Window, type: ?Application.StartupPath and hit Enter. Open the folder of the printed path and delete the add-in (while Excel is closed).