XL: Cannot Change or Delete Constraints in SolverLast reviewed: February 2, 1998Article ID: Q124499 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel 5.x, when you try to change or delete the constraints in the Solver model, you may receive an error message. If you change the constraints, you may receive the error message:
Solver: An unexpected internal error occurred, or available memory was exhausted ($C$187). Please verify that your model is correctly entered and all cells contain numeric values.If you try to delete the constraints in the Solver model, you may receive the error message:
Run-time error '13': Type mismatchIn Microsoft Excel version 7.0, when you try to change a constraint in your Solver model, you may receive the following error:
Solver: An unexpected internal error occurred, or available memory was exhausted ($C$191). Please verify that your model is correctly entered and all cells contain numeric values. CAUSEYou may receive these error messages for any/all of the following reasons:
WORKAROUND
Method 1If the worksheet has been changed, the only way to resolve this problem is to copy all the data to a new sheet, and rebuild the model (constraints) in the new sheet.
Method 2If you are using defined names, do the following to change or delete existing constraints in your Solver model:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. The problem of Deleting a constraint that uses a defined name has been fixed in Microsoft Excel for Windows 95 version 7.0. But, you may still receive an error in this version of Microsoft Excel if you try to Change a constraint that is using a defined name.
REFERENCES"User's Guide," version 5.0, Chapter 29, "Using Solver to Analyze Multiple-Variable Problems," and Chapter 30, "Examples of Using Solver" For more information about Solver, choose the Search button in Help and type:
Solver Constraints |
Additional query words: 5.00 5.00a 5.00c
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |