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 July 20, 2018 Views 35,483 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

148 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.