Forum Discussion
syedasaima
Jul 10, 2020Copper Contributor
Solver does not show up in Excel even after I added in
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 macr...
syedasaima
Jul 11, 2020Copper Contributor
I checked. It is not disabled.
JohnDenner
Jul 13, 2020Copper Contributor
I'm having the same issue but with any macros. Multiple users across our enterprise all experiencing the same issue starting Friday. Macros not working. Doesn't matter the location or the file. Any macro enabled workbook.
- NikolinoDEJul 13, 2020Gold ContributorGo to Excel Options => Add-Ins and select "Manage" Excel Add-Ins below and press "Go". There you can see whether the Solver add-in is activated.
Deactivate solver add-in => restart Excel.
Macro button should work again and the solver add-in can be reactivated.
If it doesn't help, then go through the other links / answers again.
Greetings from the beginner,
Nikolino