Thanks for your reply...

I have checkd the length and it is 543 but still I am getting following
error message

"The text string you enterted is too long reduce the number of characters
used or cancel the entry"








"JLatham" wrote:

According to Excel 2007 Help topic "Excel specifications and limits" the
maximum length for a formula in a cell is 8,192 characters. That's 8 times
as long as one could be in XL 2003. And that's one hell of a long formula!

How can you tell how long your formula is? Put a ' in front of the existing
formula, turning it into a text entry and then in another cell put
=LEN(A1)
assuming the formula is in A1.

"Milind Keer" wrote:

Hi

What is the maximum formula lenth in 2007 XL??

I have written a formula to extract the data from another worksheet in the
same XL.

Now I want to move my formula to another XL and when I try to do that it
adds the entire path of the original XL and populating an error "Lenght of
the formula is toooo big"

The size of my data sheet is very huge and thats why i want to keep two
different XL.

plz advise.

--- Milind