R
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
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