Forum Discussion

Bethanan's avatar
Bethanan
Copper Contributor
Oct 04, 2023

Formula issuer on Excel

I am currently experiencing an issue in setting the calculation option in my formula tab to Automatic as default on my Microsoft Excel
Formulas and Functions
Bethanan's avatar
Bethanan
Copper Contributor
Oct 05, 2023
Thanks for your reply

in 7th step I created new user account and I got that excel formula Automatic as the default
But now I want to make that in my existing user account
how to do that?
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 05, 2023

Bethanan 

If you created a new user account on your computer and Excel behaves correctly with the formula calculation set to Automatic in the new account, but you want to make the same change in your existing user account, you can try the following steps:

  1. Copy Excel Settings from the New User Account:

    • Log in to the new user account where Excel is working as expected with the Automatic calculation setting.
    • Open Excel and go to the "File" tab.
    • Click "Options" to access Excel Options.
    • In Excel Options, go to the "Formulas" tab.
    • Confirm that "Automatic" is selected in the dropdown for "Workbook Calculation."
    • Take note of any other settings on this page if needed.
    • Click "OK" to save the settings.

  2. Transfer Excel Settings to the Existing User Account:

    • Log out of the new user account and log back into your existing user account.
    • Open Excel and go to the "File" tab.
    • Click "Options" to access Excel Options.
    • In Excel Options, go to the "Formulas" tab.
    • Set the calculation option to "Automatic" in the dropdown for "Workbook Calculation."
    • Apply any other settings you noted from the new user account.
    • Click "OK" to save the settings.

  3. Restart Excel:

    • Close Excel completely and then reopen it. This ensures that the changes take effect.

  4. Test Excel:

    • Create a new workbook or open an existing one to confirm that the calculation setting is now set to Automatic as expected in your existing user account.

By following these steps, you should be able to transfer the Excel settings, including the calculation option, from the new user account to your existing user account, allowing you to use Automatic calculation in Excel as desired.

  • Bethanan's avatar
    Bethanan
    Copper Contributor
    Oct 05, 2023
    Above said steps won't work
    kindly give another way

    I did reinstall but no changes in that automatic calculation settings
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Oct 05, 2023
      Please provide further information. Excel version, operating system, file storage medium, does the problem only appear with a specific file?
      Additional information such as a step-by-step description of your concern and, if necessary, adding photos would also help you to provide you with a more concrete solution proposal.
      • Bethanan's avatar
        Bethanan
        Copper Contributor
        Oct 05, 2023
        Ms Office professional Plus 2021 - Version 2309
        Windows 10 Pro 22H2

        I face problem in all excel file including new file to set the calculation option to Automatic as the default
        rest all other office apps working fine

        I changed to set the calculation option to Automatic as the default.
        once I closed the excel and reopen it again the same problem on there(it turns calculation option to Manual)

        So kindly look into the problem

Resources