I have just come across a weird problem.
In Excel Tools/Options/Calculation is the option to set calculation Automatic or Manual.
Somehow one of our computers is turning this to Manual and Excel is saving it in the common Workbook we use.
What code can I use to check this status and make sure it is Automatic each time the Workbook is opened?
In Excel Tools/Options/Calculation is the option to set calculation Automatic or Manual.
Somehow one of our computers is turning this to Manual and Excel is saving it in the common Workbook we use.
What code can I use to check this status and make sure it is Automatic each time the Workbook is opened?