Cell =Now() << Can I get this to auto-update?

  • Thread starter Thread starter Paul Kraemer
  • Start date Start date
P

Paul Kraemer

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
 
Hi Paul, I'm not sure about automatically but pressing F9 should refresh the
cell

Best regards,

Gareth
 
In truth, how often do you actually need it recaculated? Does it have to be
every mili-second? Every 5 seconds? Every hour?

And does XL need to recalculate just that one cell, or the entire workbook
(think about how much processing power that could add up to).

If you *really* need it, you could implement a macro that would recalculate
your cell(s) every so many x seconds. (try a google search). But it would be
against my better judgement.
 
Back
Top