Thread: Excel 2007 will not refresh cells
View Single Post
  #2  
Old May 27th, 2010, 10:57 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
  
Posts: 607
Default 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.