+ Reply to Thread
Results 1 to 3 of 3

Function only updates when saving

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    6

    Function only updates when saving

    I have a problem with my Excel,
    Column C has a formula =-(D4-E4)*80/1000
    Column D and E will be given with values, but Column C can not automatically updates when entering a value to cloumn D & E..
    eg. Row # 2, Column C has no value, given the fact that it has a formula.

    What's happening to my Excel?
    Please help..

    Excell formula error.jpg

    A B C D E F G H
    Date Day POWER WATER

    1 Fri 0.800 11925 11935 0.70 12973 12980
    2 Sat 0.000 11936 11945 0.00 12981 12989
    Sun 0.000 0 0 0.00 0 0
    Last edited by Yu Marquez; 05-06-2016 at 09:03 PM. Reason: Will save an attachment

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Function only updates when saving

    You may have Calculate set to Manual. Try this:

    1. Click Tools and select Options.

    2. Select the Calculation tab.

    3. Under Calculation, select the radio button next to Automatic

    You have a rather old version of Excel that I no longer have access to so I can't confirm this for you.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Function only updates when saving

    Thank you so much @6StringJazzer

+ 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. Data updates in Sheet2 when there are updates in sheet1
    By pal004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2014, 10:20 AM
  2. [SOLVED] A Problem with saving old data from automated web query updates
    By 4evra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2013, 09:09 AM
  3. Recursive function that updates columns
    By lundy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 04:25 PM
  4. Replies: 3
    Last Post: 03-04-2011, 06:01 AM
  5. Function that returns worksheet name and updates on rename.
    By jr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2005, 12:05 PM
  6. Workbook.Save not saving the updates
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2005, 12:06 PM
  7. [SOLVED] Function Updates from another sheet
    By Floyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2005, 12:06 PM

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