The formula is not updating when I change a value in a cell.

Copper Contributor

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

2 Replies

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