I to am having the same problem! I changed the automatic calculation mode but
continue to have this problem. Any ideas please. I am getting frustrated! :-)

"Dave Peterson" wrote:

> 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
>