Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL: Solver Limits for Constraints and Adjustable Cells

View products that this article applies to.


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

   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.

↑ Back to the top

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

↑ Back to the top

Keywords: KB75714, kbhowto

↑ Back to the top

Article Info
Article ID : 75714
Revision : 3
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 495