Excel won't calculate
 

We have rolled out Office 2007 across the company, and this week I have had
two users with the same problem.

The have a calculation in a cell that the copy down. The formula is correct
right down the column, i.e. A1+B1 goes to A2+B2 etc... but the value all the
way down is the same as the first cell the formula is copied from. There are
no absolute values in the formula.

Is there a fix for the obvious bug? At present we can't trust Excel.

Excel won't calculate
 

In Excel 2003 it is Tools/ Options/ Calculation, and set the mode to
Automatic, not Manual.

You presumably need to do the equivalent in 2007, & the 2003 to 2007
translation utility says that the equivalent of Tools/ Options is Office
button/ Excel Options.
--
David Biddulph

"Keith" wrote in message
...
We have rolled out Office 2007 across the company, and this week I have
had
two users with the same problem.

The have a calculation in a cell that the copy down. The formula is
correct
right down the column, i.e. A1+B1 goes to A2+B2 etc... but the value all
the
way down is the same as the first cell the formula is copied from. There
are
no absolute values in the formula.

Is there a fix for the obvious bug? At present we can't trust Excel.

Excel won't calculate
 

Excel is already set to Automatic, and it doesnt happen all the time. The
same spreadsheet might work the next time after the computer has been
re-booted. Other times just closing Excel and opening it again fixes the
problem.

I'm sure its a bug in Excel 2007


"David Biddulph" wrote:

In Excel 2003 it is Tools/ Options/ Calculation, and set the mode to
Automatic, not Manual.

You presumably need to do the equivalent in 2007, & the 2003 to 2007
translation utility says that the equivalent of Tools/ Options is Office
button/ Excel Options.
--
David Biddulph

"Keith" wrote in message
...
We have rolled out Office 2007 across the company, and this week I have
had
two users with the same problem.

The have a calculation in a cell that the copy down. The formula is
correct
right down the column, i.e. A1+B1 goes to A2+B2 etc... but the value all
the
way down is the same as the first cell the formula is copied from. There
are
no absolute values in the formula.

Is there a fix for the obvious bug? At present we can't trust Excel.