hi
excel is driven by event driven programing. meaning that excel is waiting
for the user to do something. if the user does something, things happen.
updates get updated. the screen changes. wow.
if the user doen't do something....nothing happens....no code runs...just a
monotonous screen display that never changes. kind of like watching paint
dry.
if you want updates to happen ever 30 minutes (like clock work) then...
have a user on call to do something every thirty minutes or...
look into the ontime method in vb help and/or see this site...
http://www.cpearson.com/excel/ontime.htm

regards
FSt1
And after reading this post, i think i have been up too long. or had 1 beer
too many.
both?????


"Ed's" wrote:

Hey,

I am wanting to find out if the NOW() function can be updated automatically
every 30 minutes - i have a formula which changes a date to tomorrows if it
is after 5pm - but the now function obviously doesn't update automatically.

Can any bodyhelp?