I put =now() function in a cell in my companies invoice. but it does not
change according to clock displayed in tast bar.
Can it is possible?
Thanks for who will help me in advance.
I put =now() function in a cell in my companies invoice. but it does not
change according to clock displayed in tast bar.
Can it is possible?
Thanks for who will help me in advance.
calculation set to automatic.?
--
Don Guillett
SalesAid Software
donaldb@281.com
"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
news:E4D8A64B-0CF9-4E82-90A8-0B87F8CEAD2A@microsoft.com...
> I put =now() function in a cell in my companies invoice. but it does not
> change according to clock displayed in tast bar.
>
> Can it is possible?
>
> Thanks for who will help me in advance.
=NOW is not a timer - it will only update when the worksheet is calculated.
If you press and HOLD the F9 key down, it'll match the taskbar clock! But
that's not how it works. If the worksheet is not recalculated, this number
will not change.
Bob Umlas
Excel MVP
"Rao Ratan Singh" wrote:
> I put =now() function in a cell in my companies invoice. but it does not
> change according to clock displayed in tast bar.
>
> Can it is possible?
>
> Thanks for who will help me in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks