Standard Excel Solver - Messages in the Solver Results Dialog (6-8)

Messages in the Solver Results Dialog (6-8)

Solver stopped at user's request. (6)

This message appears only if you press ESC to display the Show Trial Solution dialog, and then click on the Stop button. If you are writing a VBA macro, the user may do this unless you disable the ESC key in your code, so be sure to test for this return code value (6) and take action appropriate for your application.

The conditions for Assume Linear Model are not satisfied. (7)

This message appears if you have checked the Assume Linear Model box in the Solver Options dialog, and the Solver's numeric test to ensure that the objective and constraints were indeed linear functions of the decision variables was not satisfied. In the standard Microsoft Excel Solver, this message can appear if your model is entirely linear but is poorly scaled; for more information, see the discussion of Assume Linear Model. To understand exactly what is meant by a linear model, take our Solver Tutorial, paying special attention to Optimization Problem Types.

If you receive this message, examine the formulas for the objective (Target Cell) and constraints for nonlinear or discontinuous functions or operators applied to the decision variables or adjustable cells. For more information, click on Problems with Nonsmooth and Discontinuous Functions.  You can always write a linear function using only SUM and SUMPRODUCT, or Frontline's DOTPRODUCT function.

The problem is too large for Solver to handle. (8)

This message appears when the Solver determines that there are too many decision variables or constraints in your model. In many cases you will first see a message such as "Too many adjustable cells" or "Too many constraints" when you set up the model using the Solver Parameters dialog. This message appears after you click Solve and the Solver analyzes the model for cases not checked earlier.

This message can also appear if there is an error in one of the cells on the right hand side of a constraint, so that the Solver cannot determine the size of the problem.  For example, if you have a constraint A1:A10 >= B1:B10, and B4 contains #VALUE, this message can appear.

For more information, click on Dealing with Problem Size Limits. Frontline's Premium Solver products can handle problems much larger than the standard Microsoft Excel Solver.

Next Solver Results Message >

 

< Previous Solver Results Message

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

< Back to Standard Excel Solver Support Information

To Learn More: For instant access to our white papers, example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, register now with no obligation.

User type Please Select Commercial User Consultant Corp Developer Govt/Military Professor Student VAR/ISV Firm Email address Name First Last Company University Phone

Trial version passwords are sent to the above email address. Our Privacy Policy protects you.