Solver does not show up in Excel even after I added in

%3CLINGO-SUB%20id%3D%22lingo-sub-1514100%22%20slang%3D%22en-US%22%3ESolver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%20everyone!%20I%20need%20to%20use%20the%20Solver%20in%20Microsoft%20Excel%202016%20but%20even%20after%20I%20added%20in%2C%20nothing%20shows%20up.%20Also%2C%20when%20I%20click%20on%20the%20Data%20tab%2C%20a%20pop%20up%20message%20comes%20up%20saying%20%22Cannot%20run%20the%20macro%20'OpenSolver_ModelClick'.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%22%20See%20the%20screenshot%20provided%20below.%20Would%20be%20really%20grateful%20if%20someone%20could%20help%20me%20with%20this%20Solver%20Issue.%20Also%2C%20I%20already%20uninstalled%20WPS%20Office%20as%20I%20found%20on%20a%20site%20that%20it%20might%20resolve%20the%20problem%20but%20the%20Solver%20issue%20remains.%20Please%20help%20out%20if%20you%20can%2C%20thank%20you.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Excel_Error.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204567i028C7A9298764288%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excel_Error.JPG%22%20alt%3D%22Excel_Error.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1514100%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516435%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724724%22%20target%3D%22_blank%22%3E%40syedasaima%3C%2FA%3E%26nbsp%3B%2C%20check%20to%20see%20if%20the%20add-in%20has%20been%20disabled.%20Go%20to%20Excel%20Options%20and%20select%20Add-ins%20on%20the%20left%20hand%20side.%20At%20the%20bottom%20there's%20a%20dropdown%20to%20manage%20disabled%20add-ins.%20Hope%20this%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_0-1594488740770.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204769iF027E46FE01E18B4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_0-1594488740770.png%22%20alt%3D%22TheAntony_0-1594488740770.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516467%22%20slang%3D%22de-DE%22%3ESubject%3A%20Solver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516467%22%20slang%3D%22de-DE%22%3EMany%20will%20help%20you%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20solve%20this%20problem%2C%20update%20Solver%2C%20an%20improved%20version%20of%20frontline%20systems.%20For%20more%20information%2C%20visit%20the%20Frontline%20Systems%20website%3A%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fwww.solver.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.solver.com%2F%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20could%20also%20remove%20and%20add%20solvers%20again.%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fhinzuf%25c3%25bcgen-oder-entfernen-von-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460%3Fui%3Dde-de%26amp%3Brs%3Dde-de%26amp%3Bad%3Dde%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fhinzuf%25c3%25bcgen-oder-entfernen-von-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460%3Fui%3Dde-de%26amp%3Brs%3Dde-de%26amp%3Bad%3Dde%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fhinzuf%25c3%25bcgen-oder-entfernen-von-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460%3Fui%3Dde-de%26amp%3Brs%3Dde-de%26amp%3Bad%3Dde%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fhinzuf%25c3%25bcgen-oder-entfernen-von-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460%3Fui%3Dde-de%26amp%3Brs%3Dde-de%26amp%3Bad%3Dde%3C%2FA%3E%20%3CBR%20%2F%3E%20Nikolino%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516479%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked.%20It%20is%20not%20disabled.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EE1.JPG%22%20style%3D%22width%3A%20959px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204774i41F61D903D92364B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22EE1.JPG%22%20alt%3D%22EE1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519057%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519057%22%20slang%3D%22en-US%22%3EI'm%20having%20the%20same%20issue%20but%20with%20any%20macros.%20Multiple%20users%20across%20our%20enterprise%20all%20experiencing%20the%20same%20issue%20starting%20Friday.%20Macros%20not%20working.%20Doesn't%20matter%20the%20location%20or%20the%20file.%20Any%20macro%20enabled%20workbook.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519498%22%20slang%3D%22de-DE%22%3ERe%3A%20Solver%20does%20not%20show%20up%20in%20Excel%20even%20after%20I%20added%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519498%22%20slang%3D%22de-DE%22%3EGo%20to%20Excel%20Options%20%3D%26gt%3B%20Add-ins%20and%20select%20%22Manage%22%20Excel%20Add-Ins%20below%20and%20press%20%22Go%22.%20There%20you%20can%20see%20whether%20the%20Solver%20add-in%20is%20activated.%20%3CBR%20%2F%3E%20Deactivate%20solver%20add-in%20%3D%26gt%3B%20restart%20Excel.%20%3CBR%20%2F%3E%20Macro%20button%20should%20work%20again%20and%20the%20solver%20add-in%20can%20be%20reactivated.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20If%20it%20doesn't%20help%2C%20then%20go%20through%20the%20other%20links%20%2F%20answers%20again.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Greetings%20from%20the%20beginner%2C%20%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

 
 

Excel_Error.JPG

 

5 Replies
Highlighted

@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.

 

TheAntony_0-1594488740770.png

 

Highlighted
Vieleicht hilft dir das

Um dieses Problem zu beheben, aktualisiere Solver, eine verbesserte Version von Frontline-Systeme. Weitere Informationen findest du auf der Website Frontline Systems:
http://www.solver.com/

Außerdem könntest du Solver entfernen und erneut hinzufügen.
https://support.microsoft.com/de-de/office/hinzuf%c3%bcgen-oder-entfernen-von-add-ins-in-excel-0af57...


Nikolino
Highlighted

@TheAntony 

I checked. It is not disabled. EE1.JPG

Highlighted
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.
Highlighted
Go 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