Excel 2003 maximum formula length

[DanF]

Hi - just a quicky

Who knows what the maximum length a formula can be in Excel 2003?
I've got a formula I created in Excel 2007 with 1,966 chars that I can't use
in 2003.

Cheers

 

[Dennis]

1,024 characters I think

 

[JLatham]

Dennis,
You're correct. Limit is 1024 characters in Excel 2003.

 

[Jarek Kujawa]

in Excel 2003 it is 255 chars

I think

 

[DanF]

Ok nice one, thanks

Dennis,
You're correct. Limit is 1024 characters in Excel 2003.

 

[JLatham]

You may be thinking of column width limit, which is 255 characters. Excel
2003 Help under "Excel specifications" in the Calculations group shows
formula content length as 1,024.

 

[Dave Peterson]

Just to add...

1024 characters when in R1C1 reference style.

 

[Harald Staff]

And just to add <g>, this is a pretty important distinction. "A1" may read
something like "R[-1]C[-1]", while "$A$1" is just "R1C1". Absolute
references are shorter in R1C1 notation.

 

[Pete_UK]

Harald,

in your example, how is "R1C1" shorter than "$A$1" ? <bg>

Pete

And just to add <g>, this is a pretty important distinction. "A1" may read
something like "R[-1]C[-1]", while "$A$1" is just "R1C1". Absolute
references are shorter in R1C1 notation.

Just to add...

1024 characters when in R1C1 reference style.

DanF wrote:

Dave Peterson- Hide quoted text -

- Show quoted text -

 

[Harald Staff]

Should read (or be understood as) "shorter that relative references, which
is opposite of the more common A1 notation" Sorry 'bout that.


Harald,

in your example, how is "R1C1" shorter than "$A$1" ? <bg>

Pete

 

[Pete_UK]

Yes, I realised that in the end, but it did take me a few readings for
it to sink in. <g>

Pete