Forum Discussion
Solved
Now() Function is not Updating Automatically
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...
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.
2 Replies
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.
- Many thanks! Got it...
