Excel formulas do not update

Question

This is not a file that cannot be updated, but almost all files have this issue. I have found that if another user sends me a file and the formula can be automatically updated on their computer, the formula cannot be updated properly when I enter a new cell. Can someone help me solve this problem? Thank you.

Answer 1

Hi,

It sounds like you're experiencing issues with Excel formulas not updating properly, it seems your Workbook is set to manual calculation option, I suggest you go to Formulas tab- check Calculation Options ensure that the calculation mode is set to Automatic.

If you select the Automatic option, you can try to run a simple script to help you change the Calculation option to Automatic for all Workbooks:

1. Press Alt + F11 to open the VBA editor.
2. Go to Insert > Module to create a new module.
3. Copy and paste the script into the module.

      Sub SetCalculationModeToAutomatic()
          Application.Calculation = xlCalculationAutomatic
      End Sub
   

4. Press F5 to run the script.

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.