Try changing to automatic calcuation mode.

Tools|options|calculation tab

LD wrote:
>
> We have two new computers with the latest Excel version installed. Both
> users have found that when they want to drag a formula to affect the
> subsequent rows, it is only adding the formula of the first row to all of the
> subsequent rows instead of changing the row/column number in the formula to
> affect each row (i.e. sum1b*1c - stays the same down through all of the rows
> instead of changing the next row to 2b*2c, 3b*3c,etc.
>
> Also when summing a column with formulas, the sum cell formula looks
> correct, but it did not add the numbers correctly. If I block the cells and
> look at the sum of the cell on the tool bar at the bottom of the screen, that
> sum is correct.
>
> We've never had any problems with these basic functions before. Does it
> have to do with bugs in the new Excel?

--

Dave Peterson