View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Hicks[_2_] Rick Hicks[_2_] is offline
external usenet poster
 
Posts: 1
Default Solver Iterations-how to change number

Thanks,

I found the problem in the troubleshooting. I didn't know if it was
something I would find there or if it was a trick that one of you experts
would know (the first time I trolled this site the result to my problem was a
clever little wrinkle). It turns out I got tired of looking right before I
got to it.

For anyone else stumbling onto this thread in the future, the problem I was
seeing was a "...could not find a feasible solution" message after a few
iterations. The solver would eventually work if I redid it a few times,
restarting with the previous run's results for my variables.

The solution was to check the "Use automatic scaling" box. I have a problem
where my variables range from 1 mil to 10 mil and when I start with all of
them at zero the range is too wide for the solver to deal with.

Thanks again for the help. Know there wasn't a special "trick" helped a lot.

Rick