I have a formula in cell D1 that adds together cells B1 and C1. When I
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 the
correct number from adding. I have never had this happen before and it
is effecting the whole program. Did someone change a setting on my
computer or something?


--
kola5567
------------------------------------------------------------------------
kola5567's Profile: http://www.excelforum.com/member.php...o&userid=24614
View this thread: http://www.excelforum.com/showthread...hreadid=466750

It sounds as though Calculation is set to Manual.
Got to ToolsOptionsCalculation and select Automatic

Regards

Roger Govier


kola5567 wrote:
I have a formula in cell D1 that adds together cells B1 and C1. When I
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 the
correct number from adding. I have never had this happen before and it
is effecting the whole program. Did someone change a setting on my
computer or something?

Just check in Tools/Options... Calculation tab, the Automatic checkox.
--
A+

V.


"kola5567" wrote:


I have a formula in cell D1 that adds together cells B1 and C1. When I
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 the
correct number from adding. I have never had this happen before and it
is effecting the whole program. Did someone change a setting on my
computer or something?


--
kola5567
------------------------------------------------------------------------
kola5567's Profile: http://www.excelforum.com/member.php...o&userid=24614
View this thread: http://www.excelforum.com/showthread...hreadid=466750

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)





kola5567 Wrote:
I have a formula in cell D1 that adds together cells B1 and C1. When I
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 the
correct number from adding. I have never had this happen before and it
is effecting the whole program. Did someone change a setting on my
computer or something?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466750

Perhaps ToolsOptionsCalculation has been turned to "Manual".

Try "Automatic".

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

ToolsOptionsCalculation 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

On Mon, 12 Sep 2005 06:28:18 -0500, kola5567
wrote:


I have a formula in cell D1 that adds together cells B1 and C1. When I
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 the
correct number from adding. I have never had this happen before and it
is effecting the whole program. Did someone change a setting on my
computer or something?