Add-ins have been disabled

[tom 'n' jerry]

Hiya, recently I have not been able to use Excel Dna add-in, specifically the 'xfunctions' add-in. MS Office has blocked it apparently because the source is untrusted. The error message also writes,

"The setting is enforced by your system administrator and cannot be changed."

I looked up the issue in Github issues page, couldn't find it, then came across this Group but wasn't able to navigate to find the issue conversation. So if this issue has been mentioned or resolved, could y'all point me towards it or if not could it be fixed? (ps. I don't know anything regarding programming)

[Sergey Zhilyakov]

Hi Uwe,

you might want to check whether the XLL file is blocked by Windows. Right-click on the file, choose Properties, and then select the Unblock checkbox on the General tab

For more details, see here: Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Learn

Best regards,

Sergey

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/75bcd207-7e21-4464-a15c-934cf7f5f5fcn%40googlegroups.com.

[Kedar Kulkarni]

ad the folder where addin is to the trusted folders. This can be added using registry settings and usually, they are in HKCU in the registry so it could be possible to add using regedit even if the option is disabled in excel (but it depends on the policies pushed to the user.)  

https://support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-in-microsoft-office-7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4

https://learn.microsoft.com/en-us/deployoffice/security/trusted-locations