Works Error: "Formula Too Long or Complex" (46631)



The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a

This article was previously published under Q46631

SYMPTOMS

You may receive the following error message if a Works formula has too many functions nested within it, has too many references to other cells, or is too long:
Formula too long or complex

RESOLUTION

Decrease the size or complexity of the formula. The formula is limited to 255 characters.

Works 4.0, 4.5, and 4.5a

Even though Works 4.0, 4.5, and 4.5a for Windows 95 allow 2047 characters per cell, the formula can only contain 255 characters

Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kberrmsg kbprb KB46631