Robert,

I don't have Excel 2007 on this computer, and am away from my home computer for a few days. (I assume your formulas exceed the nesting depth of 2003?)

My one suggestion is that you might add one or more hidden helper columns that simplify the formula that appears in the cell (and maybe make the formula a little more maintainable).