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