![]()
The Show Iteration Results check box allows you to examine in detail the iterations, or trial solutions, which the Solver follows in its path towards an optimal solution. When this box is checked and you click on Solve in the Solver Parameters dialog, the Solver will pause and display a dialog box like the one below on every iteration during the solution process:
This is the same dialog which appears when you press ESC at any time during the solution process, but when the Show Iteration Results box is checked it appears automatically on every iteration. When this dialog appears, the best values so far for the decision variables appear on the spreadsheet, which is recalculated to show the values of the objective function and the constraints. You may click on the Continue button to go on with the solution process, or on the Stop button to stop immediately. You may also click on the Save Scenario... button to save the current decision variable values in a named scenario, which may be brought back later with the Microsoft Excel Scenario Manager.