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?