locked
Solver in Excel does not even try to find th solution RRS feed

  • Question

  • Please help.  I use Solver in excel (PC, Office 365) often for worksheets.  A new problem is that Solver is not even trying to find the solution.  It comes back with the "cannot find solution" message.  When I look at the values which need to be changed, they all are exactly the same as before the solver was run.  Usually Solver changes at least some of the values when trying to find the solution.  I can find the solution by hand - it is not that difficult or impossible.  But time consuming.  Solver needs to wake up and do its work.  How can I change this?

    and a bit later...

    I had some Round() functions in the target cells.  Removing them got Solver going again.  Nice to know.

    • Edited by MetalsMe Monday, November 12, 2018 9:18 AM
    Monday, November 12, 2018 8:59 AM