Glad to help. Thanks for the feedback.

Fred

"Marcia" wrote in message
...
Thank you so much! I did find that out with the help of someone from my IT
dept!

Never too old to learn!

"Fred Smith" wrote:

Check:
Office ButtonExcel OptionsFormulasWorkbook CalculationAutomatic

Regards,
Fred

"Marcia" wrote in message
...
For the first time in 20 years of using Excel, I am finding that auto
calculation is not taking place whenever I add new entries to a range
of
cells included in, for example, the SUM function. I only get the
correct
results after invoking the function again. Even to calculate a
fraction,
the
correct answer is not automatically updated if the numerator or
denominator
changes. Yesterday, I emailed the worksheet I was working on to my
office
neighbour's computer and I was able to edit the sheet and get the
updated
results automatically.

Could there be something wrong with the version on Excel 2007 on my PC?

.