+ Reply to Thread
Results 1 to 4 of 4

Cells don't properly update

  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    Melbourne
    Posts
    6

    Cells don't properly update

    Hi,
    I have a spreadsheet with the following in one of the cells:

    =TODAY()-1

    This used to always print *yesterday's* date. Recently, when I open the file, it prints a date *before* yesterday - perhaps it prints the date which represents the last date the file was opened, I'm not sure.
    It is weird because if I go into and edit the cell, by simply pressing Enter, the correct value (i.e. yesterday's date) is displayed!

    Any ideas why this cell (and other similar ones) in my spreadsheet don't display the correct values unless I go into each of the cells and press Enter?
    As I say, it used to work, but doesn't anymore.

    Cheers!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Tools > Options > Calculation, tick Automatic
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-07-2008
    Location
    Melbourne
    Posts
    6
    Thanks very much! That fixed the problem.

    Seems like a crazy setting for Excel to even allow people to change.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Quote Originally Posted by chuckee View Post
    Thanks very much! That fixed the problem.

    Seems like a crazy setting for Excel to even allow people to change.
    Not really so, with automatic calculations "on" the sheet calculates when opened.
    If you have some cosmetic work to do or some changes, you have to wait that all calculations are done.
    Sometimes this can take LOTS of time ( multiple lookups f.i.)
    To avoid this some users disable the auto calculation.
    Hitting F9 calculates manually if needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Clear data in cells with validation
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-25-2008, 10:25 AM
  2. Manual calculating selected cells only
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2008, 04:05 AM
  3. Formula to add up cells with certain characters
    By tmac2o03 in forum Excel General
    Replies: 5
    Last Post: 04-20-2008, 04:18 PM
  4. sorting merged cells
    By Bope in forum Excel General
    Replies: 0
    Last Post: 04-07-2008, 11:56 AM
  5. Lock cells from auto update
    By godspeed in forum Excel General
    Replies: 1
    Last Post: 09-14-2006, 05:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1