Cell Copying Problem

  • Thread starter Thread starter kola5567
  • Start date Start date
K

kola5567

I have a formula in cell D1 that adds together cells B1 and C1. When
copy this formula in D1 down the column, the formula correctly copies
but the number in cell D1 is displayed in all the copied cells, not th
correct number from adding. I have never had this happen before and i
is effecting the whole program. Did someone change a setting on m
computer or something
 
It sounds as though Calculation is set to Manual.
Got to Tools>Options>Calculation and select Automatic

Regards

Roger Govier
 
I guess the obvious question is did your formula get entered as
=B$1+C$1 and get copied with the $ signs in ?
(ie, so that row 9 says B$1+C$1)
 
Perhaps Tools>Options>Calculation has been turned to "Manual".

Try "Automatic".

If it has been turned to manual............

Tools>Options>Calculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>


Gord Dibben Excel MVP
 
Back
Top