Shared Workbook-Formulas constantly resetting to manual

[Raewyn]

My co-worker and I use a shared workbook throughout the day. Recently, the
formulas are getting set to manual calculation. At first, I thought it was a
fluke, and reset the formulas to automatic on both of our computers. But it
seems to be resetting itself. I know that on my computer, when I leave in the
afternoon everything is set to automatic. However, when I come in in the
morning, it has changed to manual again. I have to reset it to automatic and
save the file so that it is on automatic when she comes in and opens it as
well. She swears that she is not changing the setting and doesn't even
remember where that button is. Does anyone know what might be causing it to
reset itself to manual when she saves and closes the file in the evening?
Thanks for your help.

Rae

 

[Sean Timmons]

Is she, or you, opening any other workbook that is set to Manual calculation?
This will cause your current worksheet to change as well.

 

[Raewyn]

I am sure that I am not, but I will check with her to make sure that she
double checks her other files. Thank you for your help.

 

[Sean Timmons]

No problem. One of the unforunate circumstances with Excel. Open one file
with Manual calculation and everything goes haywire.

Typically, if you see Calculate on the bottom left of your Excel app, you
are in Manual mode (Or, you haven't given Excel time to auto-calculate a
formula yet).