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.