Recalc question

  • Thread starter Thread starter newman
  • Start date Start date
N

newman

Is is possible to have an automatic worksheet recalc, say at a timed
interval, or when the worksheet is accessed?

This is required to update the now() function without having to press
F9.

Regards
 
As an aside, you should try to avoid overuse of the Now() function in your
worksheet, ideally use a named range to refer to a single cell which has this
in or directly define a name such as "TimeDateNow" as NOW().
Use this range instead in the rest of the formulae in your workbook and it
will have far less overhead than lots of repetitive NOW functions.
 
Back
Top