Solver Error Messages

Last reviewed: April 29, 1997
Article ID: Q72415

The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.x, 4.x, 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows

SUMMARY

The following is a complete list of Solver error messages. Note that references to these error messages are all documented at the bottom of this article.

Error Messages

Active document is not a worksheet.

By Changing Cells must be on the active sheet.

Cannot communicate with Solver application.

Cannot find SOLVER.XLA.

Cannot find REPORT.XLA.

Cell named in the Cell Reference box must contain a formula.

Cell Reference box is empty or contents are not valid.

Constraint must be a number, a reference, or a formula.

Load Model: Adjustable Cells reference not valid.

Load Model: Constraint formula not valid.

Load Model: Set Cell formula not valid.

Load/Save Model: Selection must be multiple cells.

Macro sent invalid problem.

Microsoft Excel did not respond in time.

Memory allocation error.

No constraint to change.

No constraint to delete.

Precision must be a small positive number.

Problem to solve not specified.

Reset all Solver options and cell selections?

Reset previous Solver cell selections?

Save Model: Selection could not hold all constraints.

Set Cell contents must be a formula.

Set Cell must be a single cell on the ACTIVE sheet.

Solver interrupted; choose Formula Solver to resume.

Solver: OK to continue iterations, Cancel to stop.

Solver to Microsoft Excel communication error.

Too many adjustable cells.

Too many constraints.

Solver cannot improve the current solution. All constraints are satisfied.

Solver could not find a feasible solution.

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

Solver stopped at user's request.

The linearity condition is not satisfied. Turn off the Assume Linear Model check box and then run Solver again.

The maximum time or iteration limit was reached.

The values do not converge.

REFERENCES

For more information about Solver errors, click the Index tab in Excel 97 Help, type the following text

   solver, troubleshooting

and then double-click the selected text to go to the topic.

For more information about Solver errors, click the Index tab in Excel 5.0 and 7.0 Help, type the following text

   solver

and then double-click the selected text to go to the "Troubleshoot problems using Solver" topic.

"User's Guide 2," version 4.0, pages 79-120 "Microsoft Excel Solver User's Guide," version 3.0, pages 20-21, 47-50


Additional query words: 97 7.00 3.0 3.00 4.0 4.00 5.0 5.00
Keywords : xladdins


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.