I've spent some time going through other forums and websites searching for ways to make Excel Solver run faster part of which is to force Excel to use more of a computer's CPA availability.

Does anyone here have suggestions as to these specific solver settings (especially when using the Evolutionary option):

1. In the "All Methods" tab, Turning off/on Automatic Scaling
2. In the same tab, reducing the Constraint Precision to a higher value? (Default seems to be .000001)
3. In the "Evolutionary" Tab, I'm assuming that a higher Convergence number will increase speed. ?
4. In the "Evolutionary" Tab, does lowering the population size increase or decrease speed?

Any other suggestions or tweaks which don't have to do with changing formulas? (e.g. registry edits)?

Thanks