+ Reply to Thread
Results 1 to 4 of 4

Auto SUM function not working correctly

  1. #1
    Forum Contributor
    Join Date
    01-15-2008
    Posts
    140

    Auto SUM function not working correctly

    i use excel 2003. have just noticed that on several of my worksheets the auto sum works but only after i have hit save. until i save any changes to the set of numbers in the auto sum do not reflect in the total. only when i hit save does the sum total adjust to the new correct number. This problem is just on the last few worksheets that i have created. On all my other worksheets the Auto SUM works correctly, showing the new total as soon as a new number is entered in the auto SUM column.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Autosum disabled

    Here is one option. But it feels like a long shot.
    http://www.mvps.org/dmcritchie/excel/grayedout.htm

    //Ola


    ... I suspect it's not: Tools>options>calculation, set it to automatic?

  3. #3
    Forum Contributor
    Join Date
    01-15-2008
    Posts
    140

    Autosum disabled

    That was it ! tools>options>calculations was set on manual. changed to Automatic and auto sum is working fine again... thank you very much...Tom

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    ...

    Happy it could be solved
    Thanks for the feedback
    Ola

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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