Formulas Calculation Options

[VCTheGreat]

So in a spreadsheet that we have to continuously update that my colleague just handed over to me, I just discovered that the Formulas Calculation Option was changed from Automatic to Manual. I would like to know if there are any instances that such switching can occur on its own without someone actually activating it.
Many thanks.

 

[joeu2004]

Generally, the calculation option is determined by the first Excel file or by the current calculation option, if you open multiple Excel files in the same Excel instance.

Also, a misbehaved macro might disable automatic calculatlon and fail to reinstate it.

If the Excel file is subsequently saved, you might permanently change the calculation option of the file.

 

[VCTheGreat]

Thanks, Joeu2004. I now know it's actually possible for the calculation option to change under certain circumstance without direct human interface.
Thanks again.