Excel sometimes sneakily changes automatic calculation to manual, causing all manner of strife!

Hi
Sometimes Excel decides to change automatic calculation to manual. It is random and most of the time it does not do it, that is why it is so destructive. All our stock orders are sent off wrong because the person using the chart, does not realize Excel has once again sneakily, quietly, performed it's sly malicious sabotage!

From research we learn that if an Excel chart is saved with manual calculation, it will always revert to that setting. This is definitely NOT what is happening. No one has ever used or required manual calculation, and we are using the same primary file on a server, which most days does not carry manual calculation setting. The server computer is also turned on and off every day.

Our primary question is.... is there any way to disable destruct, get rid off, kill or otherwise destroy 'manual calculation' so it has no chance of ever bothering us again?

Failing that, any reasonable solution to solve our problem so that manual calculation setting will not occasionally materialize on its own and wreak havoc?
 

Question Info


Last updated August 20, 2018 Views 4,818 Applies to:
Answer

Hi,

 

The only way I know of that the calculation can chaNge 'unexpectedly' is if the first workbook opened in a session is set to manual then all subsequent workbooks in that session will be in manual whEn they are opened and this catches a lot of users out. While none of your users may have deliberatly set a workbook to manual, it could have been done inadvertantly and if you have just one workbook like this then that could explain the random appearance of this problem.

 

As a workaround you can instal the code below in your workbook(s) and in time as you use them they will all eventually get saved with auto calculation.

 

ALT+F11 to open vb editor. Double click 'ThisWorkbook' and paste the code in on the right

 

Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic
End Sub

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

Mike H

5 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.