1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2007 won't update fields

Discussion in 'Business Applications' started by jackw3306, Apr 10, 2008.

Thread Status:
Not open for further replies.
  1. jackw3306

    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
     
  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    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).
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/702331

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice