Standard Excel Solver - Messages in the Solver Results Dialog

Messages in the Solver Results Dialog

These messages appear in the Solver Results dialog when the Solver stops running. The best solution values for the decision variables are placed in the adjustable (changing) cells,and the worksheet is recalculated.

In the Solver Results dialog, you have the option to keep these solution values, or restore the original values of the adjustable cells. (Clicking on Cancel or pressing ESC restores the original values without choosing any other options.)

You can also create a named scenario which captures the values of the adjustable cells, and view it later with the Scenario Manager.

Finally, you can ask the Solver to produce one or more reports as shown in the Reports list box.

• Solver found a solution. All constraints and optimality conditions are satisfied. (0)
• Solver has converged to the current solution. All constraints are satisfied. (1)
• Solver cannot improve the current solution. All constraints are satisfied. (2)
• Stop chosen when the maximum iteration limit was reached. (3)
• The Set Target Cell values do not converge. (4)
• Solver could not find a feasible solution. (5)
• Solver stopped at user's request. (6)
• The conditions for Assume Linear Model are not satisfied. (7)
• The problem is too large for Solver to handle. (8)
• Solver encountered an error value in a target or constraint cell. (9)
• Stop chosen when the maximum time limit was reached. (10)
• There is not enough memory available to solve the problem. (11)
• Another Excel instance is using SOLVER.DLL. Try again later. (12)
• Error in model. Please verify that all cells and constraints are valid. (13)

Unlike the other groups of Solver messages, this group is ordered by the result codes which can be returned when you invoke the Solver in a macro or custom program in VBA with the SolverSolve function.  Each numeric result code is shown in parentheses following the message.

Some of these messages have a slightly different interpretations, depending on whether you have selected the Assume Linear Model check box, and whether there are any integer constraints in your model. See the detailed explanations of each message, particularly the first one, "Solver found a solution."

< Back to Standard Excel Solver:  Help with Specific Solver Messages

< Back to Standard Excel Solver Support Information