Microsoft Office Tutorials and References

In Depth Information

**TROUBLESHOOTING SOLVER**

time limit, consider removing the integer constraints from the Changing Cells and rerunning Solver to see if it

finds an optimal solution that makes sense.

Restarting Solver with New Constraints

Suppose you want to start over with a completely new set of constraints. In the Solver Parameters window,

click Reset All. You will be asked to confirm that you want to reset all the Solver options and cell selections

(see Figure D-52).

FIGURE D-52

Reset options warning

If you want to clear all the Solver settings, click OK. An empty Solver Parameters window appears with all

the former entries deleted, as shown in Figure D-53. You can then set up a new model.

FIGURE D-53

Solver Parameters window after selecting Reset All