Excel forumulas not recalculating

[Mark]

I use date/time forumulas in spreadsheets and these did not compute the
date/time after the time change Sunday. When I opened the forumula and hit
"enter", the correct time showed up. What is causing this and how to fix it?

 

[Gary''s Student]

Tools > Options > Calculation > Automatic

 

[francis]

place this in a empty cell to check if your calculation is Automatic

=INFO("recalc")

if not, go to Tool >> Options >> Calculation
check on Automatic

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis

 

[Mark]

I appreciate the suggestions to make the sheet auto recalc, but this is not
the solution. It is in auto recalc mode. Even doing a manual recalc mode
will not do the trick.

Here's the formula: =F3+TIMEVALUE("05:00 PM") where F3 is a day entered by
the user. On Sunday morning, after the time change, this formula returned an
error, causing other formulas depending on it to return "time is invalid".
But when I copied the cell and pasted it's value in another cell, it was
correct.