Excel 2003 problems in calculations

[LD]

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]

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

[Jim]

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
>