Auto Sum

L

Larry

Recently updated to Office 2007 and when using a large spreadsheet (.xls)
that we developed in the 97-2003 version of Excel we are experiencing
problems with the auto sum function. When initially entering data into a
column the auto sum cell totals correctly, but when deleting or modifying one
or more of the entries in the column, the auto sum cell freezes on the last
value until you left click on the cell. The calculation option is set to
"Automatic". The other strange behaviour is that cells that use the result of
the auto sum cells automatically update to the correct value, even though the
auto sum cell reads the "old" value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top