I have a cell in excel with a the formula =SUM(J11/0.25) which results in the value 16
If I drag the bottom right corner of the cell down one cell it correctly updates the formula =SUM(J12/0.25)
The only problem is it still says 16. If I go into the formula bar at the top and click it and hit enter the cell will then display the correct value. The page was working fine but someone else was using it and now the values are not automatically updating.
Anyone know what could have caused this problem?

9/27/2006 1:52:52 PM

F9 to recalculate

or

Tools -> Options -> Calculation -> Automatic

9/27/2006 2:30:53 PM

Thank you.

9/27/2006 2:38:25 PM