Weird Excel Error Message! Please Explain...

In an Excel spreadsheet, I have adjacent rows upon rows summed by formula. Each calculated value has a little caution sign next to it, and says the following on a mouse-over:
“The formula in this cell refers to a range that has additional numbers next to it.” WTF? What kind of message is that, and why do I care?

Usually it’s like if you sum columns B thru J, if there’s numbers in column A it’s asking if you’re sure you didn’t want column A included in the formula.

Oh, I see… So, once again MS is getting too big for its britches thinking they know better than I how I want to sum my numbers! Well, thanks a lot, Mr. Gaites! Obviously, I am not smart enought to determine such things for myself!

You can turn them off but the only way I know how is using VB.
Maybe someone else knows a better way.

I’m in Excel 2007. Under “Excel Options” there is an option for “Formulas” with a section for “Error Checking.” One option there that is checked on mine is “Formulas which omit cells in a region.” Unchecking this should eliminate that message that the OP got.

Also, shouldn’t it be formulae, not formulas?