You are currently offline, waiting for your internet to reconnect

XL: Solver Limits for Constraints and Adjustable Cells

This article was previously published under Q75714
The maximum number of adjustable cells and constraints that a Solvermodel 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 ofconstraints you can use is unlimited. If you are working with a nonlinearproblem, the maximum number of constraints you can use is 500.
To determine whether a solver problem is linear or nonlinear, clickOptions in the Solver dialog box. If the Assume Linear Model check box isselected, 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
limit constraint by changing XL2000 xl2002 xl2001 xl97 xl98

Article ID: 75714 - Last Review: 09/19/2011 00:18:00 - Revision: 3.0

  • 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
  • kbhowto KB75714