Excel won't calculate

[Keith]

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.

 

[David Biddulph]

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.

 

[Keith]

Excel is already set to Automatic, and it doesn’t 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 it’s a bug in Excel 2007