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

Answer
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

159 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated January 14, 2021 Views 45,133 Applies to: