Is there a way to keep calculation mode in automatic.

[J.R.]

Does anyone know a way to always keep calculation mode in automatic. It
seems as I am working in different spreadsheets, they will change themselves
to manual calculation mode. Sometimes I do not notice that the values did
not update when I made a change.

This is really annoying. Can anyone give me the skinny on why and when this
happens? (I have also noticed that it happens more when I update or change a
formula in a cell)

I read one post that said something about the first workbook open sets the
mode...most if not all the excel files I use are in automatic mode...I am not
sure if that is the case.

I would prefer not to have to set up a macro in every spreadsheet I make to
show the mode just to prevent me from making a mistake. Is there a way to
change the setting in MS Excel as a whole? Probably wishful thinking!!!!

Thanks in advance
J.R.

 

[Gary''s Student]

This problem is usually limited to "foreign" workbooks ( those given to you)
rather than your own. If I have to work with somebody else's workbook, I
ALWAYS first open Excel with a blank, fresh, workbook and only then open the
"foreigner" with:

File > Open