Excel 2007 - Formulas not carrying over

[vnsrod2000]

Hi. I'm using Excel 2007 and all of a sudden this problem is happening...
I have a simple data table set up to calculate totals of columns.

I put the "SUM" function in the bottom row of column A and then drag it
across columns B-D to use the same function. What is happening is that the
SUM results of column A are being copied over into the other columns (B-D),
BUT when you click on those cells (B-D), the correct SUM function is there.
Here's an example:

5 6 8 5
2 3 4 1
7 7 7 7

 

[David Biddulph]

In Excel 2003, Tools/ Options/ Calculation, and set to Automatic, not
Manual.

Look up your 2003 to 2007 translation to find where this is in 2007.

 

[Gord Dibben]

Change your calculation mode to "Automatic"


Gord Dibben MS Excel MVP

 

[vnsrod2000]

Thank you, but I checked and it is set to "Automatic". Any other ideas?

 

[vnsrod2000]

Thank you- although it was already set to "automatic", the functions do seem
to be working properly again. Maybe just going in and deselecting/selecting
helped. Thanks!!