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

1,024 characters I think

"DanF" wrote:

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,
You're correct. Limit is 1024 characters in Excel 2003.

"Dennis" wrote:

1,024 characters I think

"DanF" wrote:

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

in Excel 2003 it is 255 chars

I think

Ok nice one, thanks

"JLatham" wrote:

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

"Dennis" wrote:

1,024 characters I think

"DanF" wrote:

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

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.

"Jarek Kujawa" wrote:

in Excel 2003 it is 255 chars

I think

Just to add...

1024 characters when in R1C1 reference style.



DanF wrote:

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

--

Dave Peterson

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.


"Dave Peterson" wrote in message
...
Just to add...

1024 characters when in R1C1 reference style.



DanF wrote:

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

--

Dave Peterson

Harald,

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

Pete

On Jun 30, 4:35*pm, "Harald Staff" wrote:
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.

"Dave Peterson" wrote in message

...



Just to add...

1024 characters when in R1C1 reference style.

DanF wrote:

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

--

Dave Peterson- Hide quoted text -

- Show quoted text -

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


"Pete_UK" wrote in message
...
Harald,

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

Pete

On Jun 30, 4:35 pm, "Harald Staff" wrote:
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.

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

Pete

On Jun 30, 6:04*pm, "Harald Staff" wrote:
Should read (or be understood as) "shorter that relative references, which
is opposite of the more common A1 notation" :-) Sorry 'bout that.