Re: Length limitation of cell formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

> OK, the code still errors for me. However, the formula does continue to
> work . . .

I'm confused! How can the code error yet the formula work ?

> So there may
> be no internal limitation on the formula length, but that
> knowledge/capability doesn't seem to have much practical use (at least to
> me).

I doubt anyone would or should want to create such a formula of 5000+. But
knowing about this might help a few. A long time ago I had manually created
a formula with lots of functions and references. Big but not exceptionally
so. A while later came to edit it but couldn't. In the meantime I had
renamed sheets with much longer names causing formula to exceed the 1024,
probably only by a little. Temporarily renaming the sheets did the trick,
but it took a while to figure it.

Regards,
Peter T

"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:#j5awpcRFHA.3928@xxxxxxxxxxxxxxxxxxxxxxx
> OK, the code still errors for me. However, the formula does continue to
> work as long as you don't edit it and hit enter rather than escape. I did
> edit it to see what it looked like - thus my initial response. So there
may
> be no internal limitation on the formula length, but that
> knowledge/capability doesn't seem to have much practical use (at least to
> me).
>
> --
> Regards,
> Tom Ogilvy
>


.

Quantcast