SUM does not work in Excel 2007

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hello

I have got an fantastic Excel from a nice lady, but it was in Excel 2003, so
I converted it to Excel 2007. Now when I am filling in values in that it will
not do online calculations on any of the made SUM fields. Not untill I have
pressed "Save", then it does the change. If i recreta part of the book by
doing a new book inside Excel 2007 it calculate the sum online. I am just
asking if anyone has found out a solution to this, because I would not like
to create the hole workbook with 60 worksheets, calculating here and there.
Ok now i really now whats wrong so I now to press Save every now and then, to
get right informations.
 
Likely the calculation option is set to "Manual", but with "Recalculate
before save" checked. If you can find where to access the options in ne 2007
interface, then set calculation to "Automatic" and you should be all set.

If you cannot find it, you would get a much faster reply with explicit
directions in a more appropriate discussion group (this one deals with things
that cause Excel to crash -- that doesn't happen often, so this group is not
widely read)

Jerry
 
Tom, click on the round icon on the left top of Excel 2007, then at the
bottom of the list that opens, click on Options. Select Formulas, and tick
Automatic left top. OK out.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top