Excel 2007 won't update fields

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jackw3306

Thread Starter
Joined
Jan 31, 2008
Messages
3
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
 
Joined
Jul 25, 2004
Messages
5,458
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).
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top