Bug on Excel - Calculations are not updated

Occasional Visitor

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.