Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
Anyone know how to display iterations from solver? | Excel Worksheet Functions | |||
Setting default number of iterations within ALL my excel spreadshe | Excel Worksheet Functions | |||
number of iterations as default | Excel Worksheet Functions | |||
Catching max iterations Stop of Solver in VBA | Excel Programming |