Why is my =NOW() formula not calculating when settings and cell format are correct?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
EXCEL Timestamp troubleshoot
0
Answers
0
Selected Answer
Lynn
NOW() does not update continuously but it does so on worksheet recalculation.
If you press F2 (or F9) on any cell on your sheet, recalculation occurs and the NOW() cell will be refreshed.
Hope this solves your problem. If not, please edit your Question and use the Add Files.... button to upload your Excel file for us to see.
Discussion
Thank you, for some reason F2 or F9 don't work for me. I have to activate a cell and then press enter for the time to calculate
Lynn212 (rep: 2) Feb 11, '21 at 5:18 pm
You're welcome Lynn (and thanks for selecting my answer). Glad you realised that entering that cell recalculated too. Perhaps the F keys have been re-assigned. Shift+F9 normally recalculated a sheet BTW.
John_Ru (rep: 6152) Feb 11, '21 at 5:52 pm