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?
Probably calc mode is "inadvertently" set to manual
Click Tools > Options > Calculation tab > Check "Automatic" > OK

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> 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?
Cherie - 13 Mar 2008 14:27 GMT
Thank you so much.
> Probably calc mode is "inadvertently" set to manual
> Click Tools > Options > Calculation tab > Check "Automatic" > OK
> > 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?
Max - 13 Mar 2008 20:07 GMT
welcome

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Thank you so much.