Solver Iterations-how to change number
If it quits, then Solver cannot improve the solution or it converges on a
value. Have you played with all the options in Solver? Have you decreased
the convergence?
Otherwise, perhaps you really are at the optimal value. I've found that
when setup correctly, Solver is pretty darn accurate. With all due respect
to PivotTables, I believe Solver is the most powerful and useful tool (at
least to us engineers).
Matthew Pfluger
"Rick Hicks" wrote:
Hi,
When I try to change the number of solver iterations I can't seem to
actually get it to do more than about 5. I walked through the iterations
step-by-step and after about 5 iterations it quits. If I start from that
solution a couple more times it gets to the solution, so I seem to have a
simple problem that only requires about 15 iterations but changing the number
of iterations allowed doesn't seem to have an effect. I have tried
everything that seems obvious.
Thanks.
|