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)
Whenever I open a new workbook, the calculation mode defaults to Manual. I can reset the calculation mode myself for each spreadsheet, but I would like to know how to change the default to Automatic. Can anybody help?
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.
File > Option >Formula > Calculation Options > Tick the Automatic.
In Microsoft Excel, all currently open documents use the same mode of calculation, regardless of the mode in which they were saved.
How Excel determines the current mode of calculation - Office | Microsoft Learn
Best Regards,
Snow Lu
Snow, thank you for your message.
The problem is, when I close Excel and open it again, it defaults back to manual. This default setting is what I want to change. How do I do that?
Regards
Based on my test, if you open one workbook and save the changes, it will continue that setting until another workbook with different settings.
1.Test 1
File 1 Manual.
File 2 Auto
Open File 1 then open File 2 and click save, the File 2 will change to Manual.
2.Test 2
File 1 Manual.
File 2 Auto
Open File 2 then open File 1 and click save, the File 1 will change to Auto.
3.Test 3
File 1 Manual.
Change it to Auto. Save and close. Reopen it. File 1 is still Auto.
Hope it helps. Feel free to share any update.