SOLVED

Now() Function is not Updating Automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-1959893%22%20slang%3D%22en-US%22%3ENow()%20Function%20is%20not%20Updating%20Automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959893%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20Excel%20the%20Now()%20Function%20is%20not%20updating%20automatically.....%20I%20have%20to%20press%20Enter%20for%20it%20to%20update....%20earlier%20it%20was%20not%20the%20case....%20please%20help%20out...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959893%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959923%22%20slang%3D%22en-US%22%3ERe%3A%20Now()%20Function%20is%20not%20Updating%20Automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892286%22%20target%3D%22_blank%22%3E%40muralikaja%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20Calculation%20Options%20is%20set%20to%20Automatic%20in%20the%20Calculation%20group%20of%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERemark%3A%20NOW()%20should%20be%20recalculated%20whenever%20Excel%20recalculates%20a%20formula.%20If%20there%20is%20nothing%20else%20that%20has%20to%20be%20recalculated%2C%20NOW()%20won't%20be%20updated%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
Best Response confirmed by muralikaja (New Contributor)
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.

Many thanks! Got it...