Standard Excel Solver - Messages in the Solver Results Dialog (9-10)

Messages in the Solver Results Dialog (9-10)

Solver encountered an error value in a target or constraint cell.(9)

This message appears when the Solver recalculates your worksheet using a new set of values for the decision variables (adjustable or changing cells), and discovers an error value (such as #VALUE!, #NUM!, #DIV/0! or #NAME?) in the cell calculating the objective (Target Cell) or one of the constraints. Inspecting the worksheet for error values like these will usually indicate the source of the problem.

If you have entered formulas for the right hand sides of certain constraints, the error might have occurred in one of these formulas rather than in a cell on the worksheet. For this and other reasons, we recommend that you use only constants and cell references on the right hand sides of constraints; see How the Solver handles constraints [TBD].

If you see #VALUE!, #N/A or #NAME?, look for names or cell references to rows or columns that you have deleted. If you see #NUM! or #DIV/0!, look for unanticipated values of the decision variables which lead to arguments outside the domains of your functions -- such as a negative value supplied to SQRT. You can often add constraints to avoid such domain errors; if you have trouble with a constraint such as A1 >= 0, try a constraint such as A1 >= 0.00001 instead.

Stop chosen when the maximum time limit was reached. (10)

This message appears when (i) the Solver has run for the maximum time (number of seconds) allowed in the Max Time box in the Solver Options dialog and (ii) you clicked on the Stop button when the Solver displayed the Show Trial Solution dialog.

You may increase the value in the Max Time box (to a maximum of 32767 seconds) or click on Continue instead of Stop in the Show Trial Solution dialog. But you should also consider whether re-scaling your model or adding constraints might reduce the total solution time required. For more information, see the discussion of actions you can take if the solution process takes a long time.

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.