continous update

  • Thread starter Thread starter JP
  • Start date Start date
J

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
 
JP,

Go to Tools>Options, on the Calculation tab ensure that Automatic
Calculation button is set, not the Manual.
 
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.
 
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.
 
Back
Top