ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time (https://www.excelbanter.com/excel-discussion-misc-queries/100826-time.html)

Lorri

Time

How do I get the now() time to update while I have the file open? Can this be
done or does the file stay static until I refresh it?
Any thoughts?
Thanks
Lorri

Bernard Liengme

Time

Hit F9
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorri" wrote in message
...
How do I get the now() time to update while I have the file open? Can this
be
done or does the file stay static until I refresh it?
Any thoughts?
Thanks
Lorri

Lorri

Time

Thanks........so you manually have to update the file - there's no way to
tell it to do it?

"Bernard Liengme" wrote:

Hit F9
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorri" wrote in message
...
How do I get the now() time to update while I have the file open? Can this
be
done or does the file stay static until I refresh it?
Any thoughts?
Thanks
Lorri

Bernard Liengme

Time

It will update whenever the worksheet recalculates: when you type into a
cell, edit a cell, etc.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorri" wrote in message
...
Thanks........so you manually have to update the file - there's no way to
tell it to do it?

"Bernard Liengme" wrote:

Hit F9
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorri" wrote in message
...
How do I get the now() time to update while I have the file open? Can
this
be
done or does the file stay static until I refresh it?
Any thoughts?
Thanks
Lorri

All times are GMT +1. The time now is 02:39 AM.