This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Is there a macro that is running when you open the workbook forcing to manual calc?
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).
Hi,
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.
No. Just basic Excel spreadsheets.
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).
Hi,
Excel remembers the setting of the first workbook opened in a session so if that was manual then every subsequent workbook opened will also be manual.