+ Reply to Thread
Results 1 to 2 of 2

Sum formula stops working

  1. #1
    Registered User
    Join Date
    01-07-2005
    Location
    Texas
    Posts
    5

    Question Sum formula stops working

    I have number of simple spread sheets that use the =sum command to add up a number of columns, or rows (e.g. =sum(B6:G6)). They work at the begining of the spread sheet, but stop working a few rows later. I have tried re-entering the formula and even re-wrote the spread sheet entirely, but a short time later the formulas stop working. I have already checked to make sure they are referencing the right cells. Any ideas?

    Thank you.

  2. #2
    Registered User
    Join Date
    01-07-2005
    Location
    Texas
    Posts
    5
    OK, I found the problem. If you go to Tools>Options>Calculation there are 2 radio buttons. One says Manual and the other Automatic. For some unknown reason what was once configured to make calculations automatically changed to make calculations manually. Once the Automatic radio button was chosen, the formula started calculating again.

    I knew it was something easy, it just took a while to figure it out.

+ 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