update "=TODAY()" function

[C.M.G.]

I use the =TODAY() function in a spreadsheet which may stay open on the
desktop for several days. Unfortunately, the date does not seem to turn over
at midnight; I have to close and re-open the spreadsheet.

Is there a way to make the date turn over automatically, without closing and
re-opening?

Thanks,

Clem.

 

[Guest]

Use a timed event macro to execute
Application.CalculateFull
once a day. For information on timed event macros see:

http://www.cpearson.com/excel/ontime.htm

 

[Gord Dibben]

Shouldn't have to close and re-open.

Any simple recalculation will change the date to current one.

If you have calculation mode in Tools>Option set to Manual, you may not get a
recalc.

Investigate the use of ONTime VBA method to calc the workbook after midnight.

Chip Pearson explains the ONTime method here on his site.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP

 

[C.M.G.]

Thank you for your comments.

Clem.

Use a timed event macro to execute
Application.CalculateFull
once a day. For information on timed event macros see:

http://www.cpearson.com/excel/ontime.htm

 

[C.M.G.]

Thank you for your comments.

Clem.

Shouldn't have to close and re-open.

Any simple recalculation will change the date to current one.

If you have calculation mode in Tools>Option set to Manual, you may not
get a
recalc.

Investigate the use of ONTime VBA method to calc the workbook after
midnight.

Chip Pearson explains the ONTime method here on his site.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP