XL: Solver Limits for Constraints and Adjustable Cells

ID: Q75714

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel for Windows, versions 3.x, 4.x, 5.0, 5.0c
Microsoft Excel 98 Macintosh Edition
Microsoft Excel for the Macintosh, version 3.x, 4.0, 5.0, 5.0a
Microsoft Excel for OS/2, version 3.0

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, please see the following articles in the Microsoft Knowledge Base:

Q146606 : XL: How to Find Resources on Microsoft Excel Solver

Q72415 : XL: Solver Error Messages

Additional query words: limit constraint by changing xl2k

Keywords : kbtool kbdta xladdin
Version : WINDOWS:3.0,4.0,5.0,5.0c,7.0,7.0a,97; MACINTOSH:3.0,4.0,5.0,5.0a,98; os/2:3.0
Platform : MACINTOSH OS/2 WINDOWS
Issue type : kbinfo