Formula
 

Why do I have to click the formula line every time to get the cell to update.
I put in the numbers and the cell with the formula does not update until I
click on the formula line. How do I fix this so it updates automatically?

Formula
 

Probably calc mode is "inadvertently" set to manual
Click Tools Options Calculation tab Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cherie" wrote:
Why do I have to click the formula line every time to get the cell to update.
I put in the numbers and the cell with the formula does not update until I
click on the formula line. How do I fix this so it updates automatically?

Formula
 

Thank you so much.

"Max" wrote:

Probably calc mode is "inadvertently" set to manual
Click Tools Options Calculation tab Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cherie" wrote:
Why do I have to click the formula line every time to get the cell to update.
I put in the numbers and the cell with the formula does not update until I
click on the formula line. How do I fix this so it updates automatically?

Formula
 

welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cherie" wrote in message
...
Thank you so much.