Excel Err Msg: Formula Is Too Long

 Last reviewed: November 30, 1994
Article ID: Q71283
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

Microsoft Excel for the Macintosh, version 2.2 has a maximum limit of 255 characters per cell, but there can be only 512 bytes of formula complexity. In Microsoft Excel for Windows and Microsoft Excel for the Macintosh, versions 3.0 and 4.0, the limitation of formula complexity was increased to 1024 bytes. In some cases, it is possible to enter a formula that is less than the 255-character limit and still receive the error message "Formula is Too Long." This message appears because the formula is too complex for Excel to handle in one computation.

MORE INFORMATION

Excel versions 3.0 and 4.0 are limited to 255 characters per cell or 1024 bytes of formula complexity.

For example, the INDEX function is very complex compared to the RAND function and will therefore take more memory. As a general rule of thumb, the more information the function requires, the more complex its internal computations are, and therefore the more memory the formula requires.

Excel version 2.20 is also limited to 255 characters per cell, but there can only be 512 bytes of formula complexity.

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 2.2 2.20 3.0 3.00 4.0 4.00

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.