Max Formula Lenght

[Milind Keer]

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

 

[JLatham]

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.

 

[Kevin B]

Select a cell that contains the formula that you want to copy and press F2 to
edit the cell. Place an apostrophe before the = sign in the formula and
press enter.

This converts the formula to a piece of text. Copy the formula you just
modified and paste it into the target workbook. Edit the copied and original
formula and remove the apostrophe from both. This converts the text back to
a formula.

The formula has now been copies with any references to the source path and
workbook.

 

[Milind Keer]

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"