Loop that runs every five minutes

Matis · Apr 5th, 2002, 10:31 AM

Hi, When I'm using the now function in excel, it does not update automatically.
Could I write a macro that will update the now function. Basically a macro that performs a calculate every five minutes.

Thanks is advance.
Matis

Al Chara · Apr 5th, 2002, 11:27 AM

You can have the calculate option set to manual and have the recalculate before save option checked and then install the AutoSave add-in and have it autosave every 5 minutes.

Or take a look at the OnTime function.
_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-04-05 10:29 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 10:31 AM	#1
Matis New Member Join Date: Mar 2002 Posts: 27	Hi, When I'm using the now function in excel, it does not update automatically. Could I write a macro that will update the now function. Basically a macro that performs a calculate every five minutes. Thanks is advance. Matis

Apr 5th, 2002, 11:27 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can have the calculate option set to manual and have the recalculate before save option checked and then install the AutoSave add-in and have it autosave every 5 minutes. Or take a look at the OnTime function. _________________ Hope this helps. Kind regards, Al. [ This Message was edited by: Al Chara on 2002-04-05 10:29 ]