Solver for Microsoft Excel-Office 2016 not working in Mac OS

Hi All,


I have a very good and clean installation of the latest macOS Sierra Version 10.12.4 (16E195) in my MacBook Pro and also a correct and fully updated Microsoft Office 2016 installation in it.


The Solver application in Excel, allows the assembly of the formulas and problems, all forms work perfectly but when you press the solve button it simply doesn't solve. I initially contacted Microsoft Support that found it really strange and suggested me to perform a total removal of Microsoft Office from my Mac (what I successfully did), and then to reinstall the whole Microsoft Office 2016 applying the latest update, what I also successfully did.


The problem continues to be the same and Solve does not execute the solution. My wife has another MacBook Pro updated to the same version of macOS Sierra but she runs MS Office 2011. The Solver for Excel 2011, works perfectly for the exact same problem that I try to resolve unsuccessfully in Excel 2016.


Does anyone have any idea of what might be happening, or if this a known bug somewhere?


Thanks a lot all. Best Regards,


Beck Nader

Brazil

MacBook Pro, Mac OS X (10.7.4), 2.4 GHz Intel Core 2 Duo; 4GB RAM

Posted on Apr 8, 2017 8:14 AM

Reply
2 replies

Apr 8, 2017 9:56 AM in response to FoxFifth

Hi FoxFith,


Thanks a lot! It is a fix in a flash almost. The problem is that the Solver.xlam add-in in the Portuguese Resource directory, must be replaced by the one in the English Resource directory, as simple as that. Surely it is a bug in the MS Office 2016 install.

The step by step solution is in the link you provided to me in your reply.


Best,


Beck Nader

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Solver for Microsoft Excel-Office 2016 not working in Mac OS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.