View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

I've never experienced this problem.

How are you entering your formulas? Are you typing them in the formula
bar, or directly into the cell, or are you using the Insert Function
dialog box?

Can you show an example of the type of formula you're entering?

ikarius_rb wrote:
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!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html