About =now() function

[Guest]

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.

 

[Don Guillett]

calculation set to automatic.?

 

[Guest]

=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