07-10-2020 03:44 AM - edited 07-10-2020 03:47 AM
Hello everyone! I need to use the Solver in Microsoft Excel 2016 but even after I added in, nothing shows up. Also, when I click on the Data tab, a pop up message comes up saying "Cannot run the macro 'OpenSolver_ModelClick'. The macro may not be available in this workbook or all macros may be disabled." See the screenshot provided below. Would be really grateful if someone could help me with this Solver Issue. Also, I already uninstalled WPS Office as I found on a site that it might resolve the problem but the Solver issue remains. Please help out if you can, thank you.
07-11-2020 10:32 AM
@syedasaima , check to see if the add-in has been disabled. Go to Excel Options and select Add-ins on the left hand side. At the bottom there's a dropdown to manage disabled add-ins. Hope this works.
07-11-2020 11:19 AM
07-11-2020 11:30 AM
I checked. It is not disabled.
07-13-2020 08:28 AM
07-13-2020 10:56 AM