Forum Discussion
The formula is not updating when I change a value in a cell.
I just got a new computer and have 2016 excel loaded vs. 2007. Can anyone tell me why the formula is not updating when I change a value in a cell? Is there a setting I need to change?
Thanks,
Chuck
Hi Charles,
It seems that the Calculation Option is set to Manual.
Please go to Formulas >> Calculation >> Calculation Options, and change it to Automatic.
I hope this helps you
Regards
