Error - Formula too long

[Ritu Arora]

I am writing a formula - the length of which is exceeding
1024 chars. Is it possible to do so ? I am getting an
error message - Formula Too Long. I am using Excel 2000

 

[PC]

Formula length is limited. If you post the formula
someone can probably offer a suggestion on how it can be
shortened.

PC

 

[Anon]

I am writing a formula - the length of which is exceeding
1024 chars. Is it possible to do so ? I am getting an
error message - Formula Too Long. I am using Excel 2000

1024 characters is the limit.
Formulas that long are unwieldy anyway, and very difficult to understand and
maintain.

There are obvious things to avoid this, like using shorter sheet names.
Apart from that, it may well be that what you are trying to do can be done
more elegantly, so shortening the formula considerably. Post back with some
details for help with this.