I recently upgraded to Office 2013. Ever since, if I have an Excel file open and then open another, the Workbook Calculation changes from Automatic to Manual. This can happen multiple times with one file. If I open a file, the original file I'm working
on changes to Manual Recalc. I'll going into Options and change it and then later I'll open another file. The other open files get reverted back to Manual Recalc...even the one(s) changed to Automatic. It's very frustrating. How can I make it so all my
files are Auto calc unless I change it?
Thank you for the quick response. Is there a way to turn this off? This didn't happen with our old version of Excel (I don't recall if I was using 2007 or 2010).
No you can't change this behaviour.
If the first workbook opened is manual then all subsequent ones will be as well. You've just got to hunt down the offending workbook and ensure you save it with calculation in automatic and any other ones that have had their calculation setting changed.
If this response answers your question then please mark as answer.
Did this solve your problem?
Sorry this didn't help.
Last updated: July 16, 2018