LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default Solver Iterations-how to change number

In Help, under "Troubleshoot Solver," there are a number of reasons
why Solver might stop prematurely. For instance, "For problems with
integer constraints, you need to decrease the Tolerance setting in the
Solver Options dialog box so that Solver can find a better integer
solution."

If that example isn't the problem, you might want to peruse the
others.

Mark Lincoln

On Sep 27, 3:04 pm, Rick Hicks <Rick
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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can the number of iterations repeat many times as a loop?? Jorge Luis Excel Discussion (Misc queries) 0 February 1st 08 04:15 PM
Anyone know how to display iterations from solver? Melic Excel Worksheet Functions 1 October 23rd 06 01:00 PM
Setting default number of iterations within ALL my excel spreadshe Gavin Bulman Excel Worksheet Functions 4 October 6th 06 04:38 PM
number of iterations as default Gavin Bulman Excel Worksheet Functions 0 October 6th 06 09:10 AM
Catching max iterations Stop of Solver in VBA wgaskill Excel Programming 9 November 24th 05 12:37 AM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"