date and time to automatically update

Copper Contributor

i have now() formula in excel. time and date is not changing to reflect the current time

1 Reply


The result of =NOW() will be updated whenever Excel recalculates formulas. You can force it to do so by pressing F9.

If you'd like Excel to act like a clock, that would require VBA code, but I would not recommend going that way - it has undesirable side effects.