Cell Won't Update

[Blaine]

Hi,

I have a very simple spreadsheet that totals a range of
cells in the same column, ie A1-A5.

The formula for A6 is: =sum(A1:A5)

But when you edit a value in say A1, it doesn't show up
in A6 until you manually click on the formula in A6 and
press enter.

Any ideas on what's up. If you try the same formula
anywhere else in the spreadsheet it works fine, just in
this column A.

For the life of me, I can't figure out why!!

 

[Blaine]

Nevermind,

I found out that Tools\Options\Calculation it was set to
Manual instead of Automatic.