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?