Can't fully remove xlwings addin from Excel

user_2612592 0
Viewed 2338

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

xlwings excel-addins vba excel
2 Answers

If 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 Intermediate window, type: ?Application.StartupPath and hit Enter. Open the folder of the printed path and delete the add-in (while Excel is closed).

user_9186260

You can trick Excel by saving a new file as an "xlwings.xlam" file in the same folder that Excel is looking for.

  1. Save a new file as "xlwings.xlam" in the said folder. Exit Excel.
  2. Start Excel again. Excel should not give any error messages this time since the ".xlam" file does exist.
  3. Go to Excel Add-in dialog box, check + Ok. Then uncheck + Ok on this add-in. Exit Excel. This should solve it.
  4. After this you can delete the new "xlwings.xlam" file.
user_121202830
Related