Make the solver work! (Input boxes should use the reference/range picker)
Fix the solver so that fields that take range references as inputs have the reference picker control (RefEdit), which you can click on and then select the range to use. Today, you have to manually type in the range, and it's super frustrating.
[Note: Title and Description updated on 10/19/2015 by Dan [MS]. Original description follows:)
just make it work!
Great news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!
Dan Battagin [MS XL] commented
Hi all, rather than vote for this item, please go add comments or vote on this one: http://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9426921-make-the-solver-work
Common Microsoft to slow to solve the problem!!
My Excel 2016 for Mac cannot find the Solver add-in, even if I click on Tools > Add-ins > Search. Also I see that many people cannot use it even when installed. Make it work!!!!!!
Make it work please
Please make the solver let you select the cells. It's so annoying to input them manually. You are forcing us to downgrade bro.
Bob Greenblatt commented
Not only must it work properly, it must be properly responsive to VBA. It needs to run synchronously with VBa so VB can track its progress, and issue new commands when it has comleted.
make the solver works!!!!!! for mac!
Michael Lima commented
Unable to select cells while in solver!!!! WOT! please fix this issue, because as I get into more complex problems I will not be able to enter manually
Donald Barar commented
Unable to select worksheet cells from the Solver pop-up. Other similarly constructed analysis tools hast this working, e.g. Goal Seek. Why not Solver?
Please make solver works properly. Thank you