Update current time automatically?

[JENNYC]

Hi! DOes anyone know how...if it is even possible... to display th
CURRENT time in a worksheet automatically? I am using the "now
function, but in "help" it says the time will not update unless "th
worksheet is calculated" or when a macro is run. I need to be able t
just have this page up throughout the afternoon and have an aler
message pop up 15 minutes before a "promised completion time" withou
having to do anything in the workbook. Is this possible? Any feedbac
is greatly appreciated!! thank you

 

[swatsp0p]

Seems to me what you really need is to set an appointment in Outloo
calendar and have it bring up a reminder at your desired time. Muc
easier and uses less system resources than leaving an Excel workboo
open with a macro running all day long (and it would take a macr
running all day to do what you ask).

HT

 

[JENNYC]

oh shoot!
well, I do need to do it in Excel becasue there are other conditiona
formulas tied into all this as well...i only need the timed ones to po
up 15 minutes before if it meets 2 other criteria as well...plus this i
a fairly large workbook shared by 8 other users, blah, blah, blah...i'
sure that makes little sense, sorry! Anyways, you still answered m
question, Bruce! Can't be done! I'll have to just watch the clock! :
thank you so very much though, i really appreciate your expertise!!!

Take Care,
Jenny
(also from Minneapolis by the way!

 

[Dave Peterson]

You can read about the scheduling procedures at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm

You could schedule a macro that just recalculates (over and over and ...)

(I, too, wouldn't do this. But good luck if you do!)