I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason

Jason,

go to Tools | Options | Calculation (tab) and check that Calculation
mode is set to Automatic. It sounds like this has been set to Manual in
your sheet.

Hope this helps.

Pete

On Jan 26, 7:48 pm, Laviathn
wrote:
I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason

Your Excel has been set to Manual Calculation
Use Tools | Options ; open the Calculation tab and select Automatic
This feature is for people developing very large model who do not want the
calculation to occur as they work.
BTW, Excel did not lie - the status bar warned you that a calculation was
needed. You could have pressed F9

So you need not sing "They are coming to take me away ...."
All us well
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Laviathn" wrote in message
...
I have a degree in Finance and have been using Excel for many years now,
but
came across an issue that I have never seen before and I am frustrated out
of
my mind. I have two columns of different numbers formatted as general
text. I
have entered a formula in a third column to add the two number of each
line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number!
However
when I click on an individual cell, the formula is correct. (for example,
5
cells down: =B30+C30) But it still shows the calculated total from the
first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two
columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible,
you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason

Is the TOOLS - OPTIONS - AUTOCALCULATE on?
Try F9 - if it "re-calcs" the sheet and numbers are then correct - autocalc
is OFF.


Also, if you stated it correctly (general TEXT) then you'll have problems.
It has to be GENERAL NUMBER (I believe that is what you meant to say - if
not, then re-format cell)

"Laviathn" wrote:

I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason

OMG Pete! That totally fixed it! I have no idea how that could have been
changed, but I feel soooo much better. Thank you for saving my sanity!

Jason

"Pete_UK" wrote:

Jason,

go to Tools | Options | Calculation (tab) and check that Calculation
mode is set to Automatic. It sounds like this has been set to Manual in
your sheet.

Hope this helps.

Pete

On Jan 26, 7:48 pm, Laviathn
wrote:
I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason

Common problem......not yet fixed in 2007 version.

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 MS Excel MVP

On Fri, 26 Jan 2007 12:05:02 -0800, Laviathn
wrote:

OMG Pete! That totally fixed it! I have no idea how that could have been
changed, but I feel soooo much better. Thank you for saving my sanity!

Jason

"Pete_UK" wrote:

Jason,

go to Tools | Options | Calculation (tab) and check that Calculation
mode is set to Automatic. It sounds like this has been set to Manual in
your sheet.

Hope this helps.

Pete

On Jan 26, 7:48 pm, Laviathn
wrote:
I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason