Forum Discussion
Quynh_Anh
Jan 23, 2022Copper Contributor
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
Sort By
- 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.