Forum Discussion

Quynh_Anh's avatar
Quynh_Anh
Copper Contributor
Jan 23, 2022

Bug on Excel - Calculations are not updated

Hi,

I'm encountering a bug on my Excel files.

When entering data in an Excel sheet where formulas are already set, calculations don't update anymore. The only way for me to have the calculations updated is to go in the cell where the formula is and re-enter the formula.

I have updated Microsoft Office to the newest versions. But I still have the same problem.

Can anyone help?

Thanks

1 Reply

  • Quynh_Anh 

    • Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
    • Make sure that you don't see Circular References in the status bar at the bottom of the Excel window.

Resources