Excel 2007 - Formulas not carrying over

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vnsrod2000 - 20 May 2008 18:08 GMT

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

Reply to this Message

David Biddulph - 20 May 2008 18:53 GMT

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

> 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.
[quoted text clipped - 10 lines]
> 2 3 4 1
> 7 7 7 7

Reply to this Message

vnsrod2000 - 20 May 2008 19:04 GMT

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

> In Excel 2003, Tools/ Options/ Calculation, and set to Automatic, not
> Manual.
[quoted text clipped - 17 lines]
> > 2 3 4 1
> > 7 7 7 7

Reply to this Message

Gord Dibben - 20 May 2008 19:02 GMT

Change your calculation mode to "Automatic"

Gord Dibben MS Excel MVP

>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.
[quoted text clipped - 8 lines]
>2 3 4 1
>7 7 7 7

Reply to this Message

vnsrod2000 - 20 May 2008 19:20 GMT

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

> Change your calculation mode to "Automatic"
>
[quoted text clipped - 12 lines]
> >2 3 4 1
> >7 7 7 7

Reply to this Message