Article ID: 75714
Article Last Modified on 11/16/2006
APPLIES TO
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 for Macintosh
This article was previously published under Q75714
SUMMARY
The maximum number of adjustable cells and constraints that a Solver model can use are listed in the following table.
Microsoft Excel Adjustable cells Constraints
version
---------------------------------------------------
3.x 200 299
4.x 200 500
5.0 200 500
7.0 200 500
97 200 unlimited/500*
98 200 unlimited/500*
2000 200 unlimited.500*
- If you are working with a linear problem, the maximum number of constraints you can use is unlimited. If you are working with a nonlinear problem, the maximum number of constraints you can use is 500.
MORE INFORMATION
To determine whether a solver problem is linear or nonlinear, click Options in the Solver dialog box. If the Assume Linear Model check box is selected, the problem is linear.
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
146606 XL: How to Find Resources on Microsoft Excel Solver
72415 XL: Solver Error Messages
Additional query words: limit constraint by changing XL2000 xl2002 xl2001 xl97 xl98
Keywords: kbhowto KB75714
