The Calculation Option keeps switching from Auto to Manual

Hi All,

 

One computer in our office is having an odd action. The Calculation Option keeps switching from Auto to Manual and since we don't see it, we have bogus data.

 

This doesn't happen all the time so i'm guessing it is not a setting but possibly a problem with the install.

 

Any suggestions?

 

TIA,

Sal

 

Question Info


Last updated November 13, 2018 Views 38,081 Applies to:
Answer

Hi,

 

If the first workbook you open in a session has calculation set to manual then all workbooks opened after that in the same session will also be set to manual.

 

I would guess that whoever uses this errant computer is opening a workbook with manual calculation.

If this response answers your question then please mark as answer.

Mike H

151 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.