Excel's default workbook calculation keeps changing to manual

Arthur 1 Reputation point
2022-03-23T01:58:38.083+00:00

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.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
    2022-03-23T07:51:18.927+00:00

    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.