3

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

Oliver Mohr Bonometti
  • 499
  • 4
  • 14

2 Answers2

14

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).

Felix Zumstein
  • 6,737
  • 1
  • 30
  • 62
1

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.
StudentAtLU
  • 81
  • 5