Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how
did it get set to Manual? :-)
--
ace


"Mike H" wrote:

Hi,

My guess is that calculation has been turned to manual. Do the formula
update if you tap F9?

If so
E2003
Tools|Options - Calculation tab and select automatic

E2007
Office button - Excel options - Formulas and select automatic

Mike

"ace" wrote:

Hello,

I am having this problem:

1. I enter this formula in cell D1: A1 + B1 - C1
2. The result is 10
3. I copy the formula down the column
4. All the results in column D are 10 even though the cell references are
adjusted for the new row

Help!
Thanks!
--
ace