Formula issuer on Excel

[Bethanan]

I am currently experiencing an issue in setting the calculation option in my formula tab to Automatic as default on my Microsoft Excel

[#2]

@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.

[#3]

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?

[#4]

@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.

[#5]

Above said steps won't work
kindly give another way

I did reinstall but no changes in that automatic calculation settings

[#6]

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.

[#7]

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

[#8]

@Bethanan 

Here are some steps to troubleshoot and potentially resolve this problem:

1. Excel Options:
• Open Excel.
• Click on the "File" tab.
• Click "Options" to access Excel Options.
• In Excel Options, go to the "Formulas" tab.
• Ensure that "Automatic" is selected in the dropdown for "Workbook Calculation."
• Click "OK" to save the settings. I think you already do this.
2. Registry Edit (Advanced):
• If Excel continues to revert to Manual calculation, you can try editing the Windows Registry. This should be done with caution, as it involves making changes to your system settings.
• Press Win + R to open the Run dialog box.
• Type regedit and press Enter to open the Registry Editor.
• Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\ in the left pane.
• Find the folder corresponding to your Excel version (e.g., Excel for Excel 2021).
• Inside the Excel folder, look for a subfolder called Options.
• If the Options folder does not exist, create it by right-clicking on the Excel folder, selecting "New" > "Key," and naming it "Options."
• Inside the Options folder, right-click in the right pane, select "New" > "DWORD (32-bit) Value," and name it CalculationMode.
• Double-click on CalculationMode and set its value to 1 (which corresponds to Automatic calculation).
• Click "OK" to save the value.
• Close the Registry Editor.
3. Repair Office Installation:
• Sometimes, issues like this can be caused by corrupted Office installations. You can try repairing your Office installation:
• Go to "Control Panel" > "Programs" > "Programs and Features."
• Select "Microsoft Office" and click "Change."
• Choose "Repair" and follow the prompts to repair your Office installation.
4. Update Office:
• Ensure that your Microsoft Office installation is up-to-date with the latest updates and patches. Outdated software can sometimes lead to unexpected issues.
5. Check for Add-ins or Macros:
• Add-ins or macros in Excel can sometimes interfere with settings. Temporarily disable any add-ins or macros and see if that resolves the issue.
6. Check for Group Policy Settings:
• If your computer is part of a network managed by an IT department, there may be Group Policy settings that are affecting Excel. Check with your IT department for any policies related to Excel settings.
7. Try a Different User Profile:
• Create a new user profile on your computer and see if Excel behaves differently when used from that profile. This can help determine if the issue is specific to your user profile.

Please remember to back up your data and be cautious when making changes to the Windows Registry. The text and the steps are the result of various AI's put together.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.