Excel Solver - Solver Result messages

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.

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."

• Excel Solver - Solver found a solution. All constraints and optimality conditions are satisfied (0).
• Excel Solver - Solver has converged to the current solution. All constraints are satisfied (1).
• Excel Solver - Solver cannot improve the current solution. All constraints are satisfied (2).
• Excel Solver - Stop chosen when the maximum iteration limit was reached (3).
• Excel Solver - The Objective Cell values do not converge (4).
• Excel Solver - Solver could not find a feasible solution (5).
• Excel Solver - Solver stopped at user’s request (6).
• Excel Solver - The linearity conditions required by this LP Solver are not satisfied (7).
• Excel Solver - The problem is too large for Solver to handle (8).
• Excel Solver - Solver encountered an error value in the objective cell or a constraint cell (9).
• Excel Solver - Stop chosen when the maximum time limit was reached (10).
• Excel Solver - There is not enough memory available to solve the problem (11).
• Excel Solver - Error in model. Please verify that all cells and constraints are valid (13).
• Excel Solver - New Messages in Excel 2010 and Excel 2011