excel solver
optimization
simulation
messages, Solver Results Dialog

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   
support, help, question

Standard Excel Solver - Messages in the Solver Results Dialog


solver results messages

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
Developers
MATLAB Users
Macintosh Users
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 
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.

bulletSolver found a solution. All constraints and optimality conditions are satisfied. (0)
bulletSolver has converged to the current solution. All constraints are satisfied. (1)
bulletSolver cannot improve the current solution. All constraints are satisfied. (2)
bulletStop chosen when the maximum iteration limit was reached. (3)
bulletThe Set Target Cell values do not converge. (4)
bulletSolver could not find a feasible solution. (5)
bulletSolver stopped at user's request. (6)
bulletThe conditions for Assume Linear Model are not satisfied. (7)
bulletThe problem is too large for Solver to handle. (8)
bulletSolver encountered an error value in a target or constraint cell. (9)
bulletStop chosen when the maximum time limit was reached. (10)
bulletThere is not enough memory available to solve the problem. (11)
bulletAnother Excel instance is using SOLVER.DLL. Try again later. (12)
bulletError 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

To Learn More:
For instant access to example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, you can register now.
User Type
Email Address
Name First Last
Company University
Phone

Trial version passwords are sent to the above email address: See Privacy Policy.
Our Premium Solver Platform works with existing Excel Solver models, solves much larger problems up to hundreds of times faster, and solves new kinds of problems via Evolutionary Solver.  Solver Engines plug into the Premium Solver Platform.
   
Solver Platform SDK makes it easy to solve any type or size of optimization problem in your Visual Basic, VB.NET, C/C++, C#, Java, or MATLAB program. And it's easy to deploy your application with our flexible licensing for software vendors and corporate developers.
   
spreadsheet solver
scarce resources