Excel 2007 won't update fields

[jackw3306]

I have a time sheet that won't change any fields. The month has a dropdown box to select the current month. Selecting a different month (say June instead of May) doesn't change the day and mm/dd. Changing start or end time doesn't update the HOURS.
If I manually change every formuls in the sheet, the caclulations work.
ANY suggestions what the problem could be?

May, 2008

Day Date From To Code Hours
Tue 04/01 6:00 AM 6:00 PM S 12.0
Wed 04/02 6:00 AM 6:00 PM S 12.0
Thu 04/03 5:30 AM 6:30 PM S 13.0
Fri 04/04 5:00 AM 11:00 AM S 6.0

 

[Zack Barresse]

Hi there, welcome to the board!

It really sounds like your sheet calculation state is in manual calculation. Check the state and put it in automatic. Or try the keyboard shortcuts (Ctrl + Alt + Shift + F9, which will do a full workbook recalculate and restructure the dependencies list, or just Shift + F9 will recalc the current sheet).