Excel's default workbook calculation keeps changing to manual

Question

Got myself a new laptop, after installing Office 365, my Excel's default workbook calculation keeps changing to manual, even though I did not open a file which had manual calculations saved before. Even after I change the settings to be automatic calculations, and saving the file, the calculation reverts to be manual immediately after re-opening the file.

I have tried saving a blank workbook with automatic calculations in the XLstart folder, but to no avail.

An odd thing to point out is that when I start up Excel, at the welcome page where we can create a new blank workbook or start from a template, when I click on Options, I can see that the calculation settings are automatic, and when I create a blank workbook straight after, the settings are automatic. However, if I do not do the step where I click on options to check the calculation settings, the settings start as manual.

Please help.

Answer 1

Hi,
If you open an Excel file and set the calculation mode to Automatic, then open another Excel file that has been saved in Manual mode, it will NOT change to Automatic mode. Conversely, if you open an Excel file that has been saved in Manual mode, then open another Excel file saved in Automatic mode, it will CHANGE to Manual mode.

As a workaround, you can create a Personal.xlsb on: UserName\AppData\Roaming\microsoft\excel\Xlstart folder

When you saved the file "Personal.xlsb" in the Xlstart Folder, open an Excel file and press ALT+F11

On the left side, open the VBAProject(Personal.xlsb) and double click on ThisWorkbook and paste this code:

Private Sub Workbook_Open()  
     Application.Calculation = xlCalculationAutomatic  
 End Sub  

Then save it and restart Excel.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

If I understand Emi Zhang-MSFT statement, I found that Excel behaves differently. The first workbook that I opened shows its calculation options set to automatic, likewise with subsequent workbooks. However, when I open the last file and set its calculation options to manual, all currently open files are changed to to manual as well. I have tried this multiple times, with the same results. I am using Excel 365, MSO (Version 2402 Build 16.0.17328.20550) 64-bit.