Excel Solver not working

%3CLINGO-SUB%20id%3D%22lingo-sub-890127%22%20slang%3D%22en-US%22%3EExcel%20Solver%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890127%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20running%20Windows%2010%2C%20Office%20365%2FExcel.%26nbsp%3B%20The%20add-in%20Solver%20doesn't%20work%20though%20Goal%20Seek%20works%20fine%20for%20the%20solution%20to%20the%20same%20set%20of%20data.%26nbsp%3B%20%26nbsp%3B%20I%20tried%20uninstalling%2Freinstalling%20Solver%20without%20benefit.%26nbsp%3B%20Also%20ran%20the%20Quick%20Repair%20app%20from%20Control%20Panel%20without%20benefit.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-890127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477971%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477971%22%20slang%3D%22en-US%22%3E%3CP%3EHaving%20just%20struggled%20with%20this%20problem%20here%20is%20what%20worked.%20I%20just%20moved%20from%20Office2016%20to%20Office365%20Even%20though%20I%20had%20originally%20been%20running%20a%2064%20bit%20install%20on%20Office%202016%20and%20Windows%2010%20is%20a%2064%20bit%20version%2C%26nbsp%3B%20with%20Office365%20I%20needed%20to%20install%20the%2032%20bit%20version%20in%20order%20to%20resolve%20the%20problem.%20The%20issue%20appears%20to%20be%20with%20the%20Solver32.dll%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I'm running Windows 10, Office 365/Excel.  The add-in Solver doesn't work though Goal Seek works fine for the solution to the same set of data.    I tried uninstalling/reinstalling Solver without benefit.  Also ran the Quick Repair app from Control Panel without benefit.  Any suggestions?

1 Reply
Highlighted

Having just struggled with this problem here is what worked. I just moved from Office2016 to Office365 Even though I had originally been running a 64 bit install on Office 2016 and Windows 10 is a 64 bit version,  with Office365 I needed to install the 32 bit version in order to resolve the problem. The issue appears to be with the Solver32.dll file.