View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Kraemer Paul Kraemer is offline
external usenet poster
 
Posts: 34
Default Cell =Now() << Can I get this to auto-update?

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