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!
Begun! Very good ! But what date can we expect to have a solver in working order? I work in supply chain and this tool is completely essential in this profession.
also would need to resolve the quasi-systematic VB error 1004 ...
James Spotanski (Microsoft Excel) commented
We're working on putting cell selection (RefEdit) back into Solver and custom VBA UserForms. We know this is super important to students and professionals, and we hope to have it ready for you all in early 2016.
I am extremely disappointed that the Solver-Add-In and inserting data into the X and Y column on a scatter plot both are glitchy on Microsoft 2016. I am a Mac and PC user, and I am uninstalling Microsoft 2016. It goes to show that the fact that neither of these two functions work in Microsoft 2016, and they are both equally important for calculations in my chemical engineering courses. Why would Microsoft release a new software if there are this many glitches and their older products function better?
Yes this really needs fixing. Solver is a crucial part of excel for many and it is basically unusable in its current state!
Larry Yuen commented
Please fix this with an update! I agree with all the others on the forum. It is very frustrating to have to type all the formulas into the solver particularly in models with a lot of constraints. In Excel 2011 for Mac it works so well, I am just not sure why it seems like we are moving backwards. Is it El Capitan that broke it or is it something that MS needs to fix? Please fix.
Please fix solver. It takes to much time to manually write the input of the cells. I purposely bought excel for solver and now i can not use it efficiently. As of now people are told not to get excel 2016 for this reason. Please fix!
Please fix solver for mac 2016. You can't reference cells, and have to insert them manually, and once you insert them manually you get an error message when you try to solve anyways.
Luis Chavez commented
Seriously, come on Microsoft. I'm a freaking student who's homework relies on this. I'm blaming you for my terrible GPA. You'll have to talk to parents about this one U_U
Ridiculous that such a basic functionality as being able to choose reference cells is missing in Excel 2016 Solver!
Please fix asap!!
I teach a class in Excel! This is embarrassing! Needs to be fixed ASAP!!!! How can you not have this feature that was always there? I don't understand! Fix needs to be a matter of days, come on Microsoft!!!
I need the solver for using simplex for my university course...please fix the cells selection!
Yeah. This is a really serious problem and almost completely destroys the functionality of the Solver for 2016. This one deserves to be a high priority fix.
I need this to work for class!
Fix the solver issues please, i cant see the cell select button. Thanks !
Velo Anses commented
Please make solver works properly. Thank you
Please fix solver select button in Excel 2016
José Vicente commented
TOTALLY UNHAPPY, switched from Office 2011 to 2016 and i cannot believe that I need to switch back to 2011 now.
Do your job well please and fix this issue
It's so annoying to have to continually close and re-open!
Jay Jasinowski commented
Let me select cells using solver rather than manually inputting them. Very unhappy with your product at this moment.