Today not changing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 31 Jan 2005 08:23 GMT

Hello.
I'm using the formula :
=TODAY()-30
The workbook remains open overnight.
When the date changes, there is no change in the cell value. I'll appreciate
some kind of automation (VBA OnTime ?).
Thanks in advance.
Daniel

Reply to this Message

Arvi Laanemets - 31 Jan 2005 09:42 GMT

Hi

Formulas in excel are recalculated whenever they are triggered. When there
are volatile functions used in formula, the formula is recalculated whenever
some cell entry is changed. Otherwise the formula is recalculated when some
of formula's parameters is changed.

TODAY is recalculated whenever something is changed in any cell.

Maybe you write a windows script, which closes and reopens your workbook
after midnight. Another option is to write an timer event for your workbook,
which recalculates the workbook at given time. But I'm not sure how this
will affect your workbooks performance - you have to use some cycle, because
there Excel misses built-in timer event.

Signature

When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets

> Hello.
> I'm using the formula :
[quoted text clipped - 4 lines]
> Thanks in advance.
> Daniel

Reply to this Message

Bob Phillips - 31 Jan 2005 10:16 GMT

Just hit the F9 key at the start of your working day.

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Hello.
> I'm using the formula :
[quoted text clipped - 4 lines]
> Thanks in advance.
> Daniel

Reply to this Message