Solver Limits for Constraints and Adjustable Cells

Last reviewed: February 2, 1998
Article 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 Macintosh, versions 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*

* 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:

   ARTICLE-ID: Q146606
   TITLE     : XL: How to Find Resources on Microsoft Excel Solver

   ARTICLE-ID: Q72415
   TITLE     : Solver Error Messages

REFERENCES

"Microsoft Excel Solver User's Guide," version 3.0, page 50.

"Microsoft Excel User's Guide 2," version 4.0, Chapter 2, "Learning to Use Microsoft Excel Solver"

For more information about Solver limits in Microsoft Excel 97, click the Index tab in Microsoft Excel Help, type the following text

   limits in solver

and then double-click the selected text to go to the "Add a constraint in Solver" topic.


Additional query words: limit constraint by changing XL98 XL97 XL7 XL5 XL4
XL3
Keywords : xladdin kbtool
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 : kbref


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.