A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This is likely a User Account Control (UAC) issue since the add-in works in Excel Online and also works when you are signed out of your account, which indicates that the add-in itself is functioning correctly. To fix this, close all Office applications and open Microsoft Excel as an administrator by finding the Excel application in the Start menu or on your desktop, right-clicking it, and selecting Run as administrator.
If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin