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.