formula fill not working correctly in 2007

[Guest]

If I use the fill handle to copy a formula, the formulas are well copied, but
the results are not. Exemple: The formula in A3 is =A1+A2. If I copy the
formula to B3 it reads =B1+B2, which is correct. The result given in B3
however is not B1+B2 but the same result as in A3. I have to recalculate the
formule in B3 for the correct result. In previous versions Excel did this
automatically. How can I fix this problem or is it a bug?

 

[Roger Govier]

Hi

It sounds as though calculation is set to Manual.
Tools>Options>Calculation>and select Automatic

 

[Mike Middleton]

In Excel 2007, it's Office Button | Excel Options | Formulas | (Calculation
options) Automatic.

- Mike
http://www.mikemiddleton.com

 

[Guest]

Thankt you, I found it. I thought I had a clean installation of Excel 2007
and I'm suprised that the automatic calculation is not the standard setting.
Or am I mistaken?

Jante

 

[Gord Dibben]

Jante

Common problem......not yet fixed in 2007 version.

Tools>Options>Calculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>


Gord Dibben MS Excel MVP