continous update

[JP]

I want my functions to continuously refresh themselves
automatically. I used to have a now function in a cell
and the time would continuously update itself but now it
has stopped and I don't know why. The time will refresh
if I hit F9 but not on its own. Under the tools menu I
went to options and calculation is already set to
automatic? Thanks

 

[Bob Phillips]

JP,

Go to Tools>Options, on the Calculation tab ensure that Automatic
Calculation button is set, not the Manual.

 

[JP]

I checked again and it definatly is set to automatic but
it still doesn't continously update. The function I want
to work specifically is the now function. Thanks.

 

[Norman Harker]

Hi JP!

With calculation set to automatic, volatile functions such as NOW will
only recalculate when Excel recalculates. This includes events that
trigger a recalculation such as inserting or deleting rows, columns or
cells.

For details generally on volatility see:

Charles Williams:
http://www.decisionmodels.com/calcsecretsj.htm

You can however force a recalculation periodically using a VBA
subroutine that uses the OnTime method associated with the Application
object. For details of this see VBA Help. I can't say that I'd
recommend continuous updating.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 12th August 2003: Peru (Arequipa
Week), Sri Lanka (Esala Full Moon Poya Day), Thailand (H.M. Queen
Sirikit Birthday, also Mother's Day), Zimbabwe (Defense Forces Day).
Observances: Farvardigan (Muktad) (Zoroastrian), Tibet (Qiangtang
Kyagqen Horse Racing Festivals).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.