Solver

%3CLINGO-SUB%20id%3D%22lingo-sub-720091%22%20slang%3D%22en-US%22%3ESolver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720091%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20want%20to%20use%20Solver%20Add%20on%20my%20Excel%20doc%20but%20it%20doesn't%20work.%20My%20friend%20who%20has%20the%20same%20version%20(%20given%20by%20our%20school)%20doesn't%20have%20any%20problem.%20Where%20does%20it%20come%20from%3F%3C%2FP%3E%3CP%3EI%20did%20the%20same%20thing%20on%20both%20computer%20but%20the%20result%20isn't%20the%20same.%26nbsp%3B%20Can%20you%20help%20me%20%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120602i18BE01FB160D61BB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22erreur_solver.PNG%22%20title%3D%22erreur_solver.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-720091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESolver%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-720378%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366508%22%20target%3D%22_blank%22%3E%40hugo1855%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESolver%20is%20a%20third%20party%20add-in%20provided%20by%20Microsoft.%26nbsp%3B%20It%20needs%20to%20be%20enabled%20(in%20English%20Options%20%2F%20Add-ins%20%2F%20Manage%20Excel%20Add-ins%20%2F%20Go...)%20and%20then%20it%20should%20appear%20on%20the%20Data%20ribbon%20tab.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1512264%22%20slang%3D%22es-ES%22%3ERe%3A%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512264%22%20slang%3D%22es-ES%22%3EI%20did%20that%20and%20I%20don't%20think%20there's%20a%20file%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523984%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F723818%22%20target%3D%22_blank%22%3E%40davidcastilla%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20remember%20in%20old%20versions%20of%20Excel%2C%20Solver%20had%20to%20be%20specifically%20selected%20when%20installing%2Frepairing%20Excel%20from%20disk.%26nbsp%3B%20Perhaps%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bor%20some%20other%20might%20know%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524110%22%20slang%3D%22de-DE%22%3ESubject%3A%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524110%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%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%20Or%20update%20Solver%2C%20an%20improved%20version%20of%20Frontline%20systems.%20For%20more%20information%2C%20go%20to%20the%20Frontline%20Systems%20website%3A%20%3CBR%20%2F%3E%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%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%20solver%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-0af57%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fhinzuf%25c3%25bcgen-oder-entfernen-von-add-ins-in-excel-0af57%3C%2FA%3E...%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20If%20all%20of%20this%20is%20not%20enough%20...%20a%20last%20try%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fsolver-does-not-show-up-in-excel-even-after-i-added-in%2Fm-p%2F1514100%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fsolver-does-not-show-up-in-excel-even-after-i-added-in%2Fm-p%2F1514100%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, i want to use Solver Add on my Excel doc but it doesn't work. My friend who has the same version ( given by our school) doesn't have any problem. Where does it come from?

I did the same thing on both computer but the result isn't the same.  Can you help me ?erreur_solver.PNG

4 Replies

@hugo1855 

Solver is a third party add-in provided by Microsoft.  It needs to be enabled (in English Options / Add-ins / Manage Excel Add-ins / Go...) and then it should appear on the Data ribbon tab.

Yo hice eso y me parece que no existe el archivo

@davidcastilla 

I remember in old versions of Excel, Solver had to be specifically selected when installing/repairing Excel from disk.  Perhaps @Sergei Baklan or some other might know more.

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.

Or update Solver, an improved version of Frontline systems. For more information, go to the Frontline Systems website:

http://www.solver.com/

You could also remove and add solver again.
https://support.microsoft.com/de-de/office/hinzuf%c3%bcgen-oder-entfernen-von-add-ins-in-excel-0af57...

If all of this is not enough ... a last try
https://techcommunity.microsoft.com/t5/excel/solver-does-not-show-up-in-excel-even-after-i-added-in/...

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)