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
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 04, 2023

    Bethanan 

    If you are experiencing issues with Excel not allowing you to set the calculation option to Automatic as the default, it might be due to several reasons. Here are steps to troubleshoot and resolve the issue:

    1. Excel Options:
      • Click on the "File" tab in Excel.
      • Go to "Options" at the bottom of the left-hand menu.
      • In the Excel Options dialog box, click on the "Formulas" tab on the left.
      • Under "Calculation options," make sure "Automatic" is selected in the dropdown for "Workbook Calculation."
      • Click "OK" to save the changes.
    2. Workbook-Specific Settings:
      • Open the workbook where you want the calculation to be set to Automatic.
      • Go to the "Formulas" tab on the ribbon.
      • In the "Calculation" group, check if the dropdown menu next to "Calculation Options" shows "Automatic." If it doesn't, click the dropdown and select "Automatic."
    3. Template or Default Workbook:
      • If you have a template or a default workbook that you use to create new Excel files, make sure that the calculation option in that template is also set to Automatic. Any new workbooks created from the template will inherit this setting.
    4. Workbook Recalculation Issue:
      • If you are still experiencing issues with calculation, it is possible that there may be issues with the workbook itself. Try creating a new workbook and see if the calculation options work as expected in the new file.
    5. Add-ins or Macros:
      • Sometimes, Excel add-ins or macros can interfere with the calculation settings. Temporarily disable any add-ins or macros and see if that resolves the issue.
    6. Excel Repair or Reinstallation:
      • If none of the above steps work, you can try repairing your Excel installation or even reinstalling Excel to reset any settings that might be causing the issue.
    7. System User Settings:
      • In rare cases, the issue might be related to user-specific settings on your computer. Try creating a new user profile on your computer and see if Excel behaves differently when used from that profile.
    8. Check Excel Updates:
      • Ensure that your Excel application is up-to-date with the latest updates and patches. Sometimes, issues are resolved through updates.
    9. Group Policy or IT Policies:
      • If you are part of a larger organization, check if there are any Group Policy or IT policies that are enforcing specific Excel settings.

     

    The text was created with the help of AI.

     

     

    Hope this will help you.

    • 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
        Gold 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.

Resources