Length of Formulas in Name Manager

hello

i came across today. that i couldnt enter the long formula in name manager under "Refers To", i had to shorten the tab names in order to enter formula in name manager..

1- is there anyway to override the length of the formula needed in name manager??

2- what do i do.. if i add one more string to the formula, even if the name manager doesnt accept the length?

3- how long does the excel support only??

thanks for helpin out

regards

Hello Martin,


i think its less than 1024 characters in a line.. but its around 50 letters or character in a formula line...

greetings

Sultix,

Suggest you break down your formula and encapsulate parts of it names then refer to those names in the larger formula you wish to create.