Excel 2007 will not refresh cells
 

I am currently using Excel 2007. I have a spreadsheet that I want to use to
do some analysis of various situations. So here is my problem. I have
several columns that have totals at the bottom. I have no problem getting
the columns to total initially. However, if I plug in another number in the
column, the total stays the same and won't refresh or re-total the column. I
don't recall that this was a problem when I worked with Excel 2003. Can
someone please tell me how to get the totals to update when I enter some new
numbers in the column? Thanks in advance for the help.

Excel 2007 will not refresh cells
 

Is calculation set to automatic?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DY" wrote in message
...
I am currently using Excel 2007. I have a spreadsheet that I want to use
to
do some analysis of various situations. So here is my problem. I have
several columns that have totals at the bottom. I have no problem getting
the columns to total initially. However, if I plug in another number in
the
column, the total stays the same and won't refresh or re-total the column.
I
don't recall that this was a problem when I worked with Excel 2003. Can
someone please tell me how to get the totals to update when I enter some
new
numbers in the column? Thanks in advance for the help.