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...
View best response
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.