Hi Paul, I'm not sure about automatically but pressing F9 should refresh the
cell

Best regards,

Gareth

"Paul Kraemer" wrote:

Hi,

I am using Excel 2007. In one cell, I entered the following formula:

=Now()

After I typed in the formula and hit <Enter, my cell displayed the current
time when I hit <Enter. I was hoping that as time went by, the value in my
cell would be constantly updated so as to reflect the current time.

Currently, the only way I can get the value in my cell to update is to go to
Formulas | Calculation Group and select "Calculate Now". Is there anyway I
can make my cell update automatically without having to do this?

Thanks in advance,
Paul
--
Paul Kraemer