Now() Function is not Updating Automatically

[muralikaja]

In my Excel the Now() Function is not updating automatically..... I have to press Enter for it to update.... earlier it was not the case.... please help out...

[#2 · Accepted solution]

@muralikaja

Make sure that Calculation Options is set to Automatic in the Calculation group of the Formulas tab of the ribbon.

Remark: NOW() should be recalculated whenever Excel recalculates a formula. If there is nothing else that has to be recalculated, NOW() won't be updated either.

[#3]

Many thanks! Got it...