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