I am constantly running into this horrible design decision to auto-check
excel formulas as they are typed. I type in formulas, then add parentheses
from the right hand side back to the left to make certain of the calculation
orders. Every time I put in a close paren and then move backwards to add the
opening paren, Excel interrupts me and pops up a dialog telling me my formula
is broken..... WHILE I AM STILL TYPING IT. The worst part is that it
requires two clicks of non-default options that alternate positions (i.e. I
have to move the mouse t the correct button two separate times) in order to
go back to typing my formula. I have turned off every auto-check option
there is, and it still does this. GIVE ME A WAY TO TURN THIS OFF!