How can I avoid relying on these workarounds to use my add-ins comfortably? Start Excel again and the add-ins will show in the Ribbon tabs. Realize that Excel is still running, and kill the process (End Task).
Go to the COM add-ins manager, untick+OK and retick+OK the COM add-ins.Yet, the add-ins show as being loaded in the COM Add-ins manager window. Relaunch Excel and all COM add-ins have disappeared: the UI in the Ribbon tabs do not appear, as if the Add-ins were not loaded.Then close the workbook and any other Excel windows. Restart your computer, run Excel and choose new blank workbook: all COM add-ins show as expected.Following an update of Office 365 in March or April 2022, my COM Add-ins for Excel started to disappear: