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?

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

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

Has this problem been corrected for you yet? I am also having problems with
this recently which caused me to look thru the chat room to see if there were
similar problems and yours is exactly the problem that I have. Have you
found a solution?

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

After such a long time, it's probably more effective to start a new thread, describing exactly what your problem is

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"DB" wrote in message ...
| Has this problem been corrected for you yet? I am also having problems with
| this recently which caused me to look thru the chat room to see if there were
| similar problems and yours is exactly the problem that I have. Have you
| found a solution?
|
| "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?