Excel 2007 - Formulas not carrying over
 

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

Excel 2007 - Formulas not carrying over
 

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.
--
David Biddulph

"vnsrod2000" wrote in message
...
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

Excel 2007 - Formulas not carrying over
 

Change your calculation mode to "Automatic"


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 10:08:03 -0700, vnsrod2000
wrote:

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

Excel 2007 - Formulas not carrying over
 

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

"David Biddulph" wrote:

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.
--
David Biddulph

"vnsrod2000" wrote in message
...
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

Excel 2007 - Formulas not carrying over
 

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!!

"Gord Dibben" wrote:

Change your calculation mode to "Automatic"


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 10:08:03 -0700, vnsrod2000
wrote:

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