1) A recent update to Excel has blocked access to the “OpenSolverNomad.dll” file that we use to execute the NOMAD solver. Symptoms of this include the “About OpenSolver” window crashing with an error. Errors also occur when trying to use the NOMAD solver. We don’t currently have work around for this. We would welcome user feedback on any settings change that lets Excel use this DLL. Please email email hidden; JavaScript is required if you have a solution that works.
2) According to StackOverflow, a recent update has also changed the default ActiveX settings in Excel to a stricter level. This disables controls from external libraries like RefEdit; we use RefEdit in our dialogs. So, in recent Excel versions, permission to use ActiveX controls must be turned on in the Excel Trust center (under File…. Options… Trust Center… Trust Center Setting). More details are in our help pages.
https://learn.microsoft.com/en-us/answers/questions/1455eddb-d8aa-4700-ab40-ad3e22a3d5c1/ms-office-macro-not-able-to-read-dll-files?forum=msoffice-all&referrer=answers