Formulas DO NOT calculate by themselves

[Xavier]

I have no idea what option I pressed, but no formula on
any of my spreadsheets is calculating by itself. I have
to click on the cell, press F2 and hit enter in order to
perform the operation.

ANY IDEAS???? GOING BANANAS !!

Thanks !!
-xavier

 

[Gord Dibben]

Xavier

Tools>Options>Calculation. Make sure "auto" is checked.

Some facts about Excel and Calculation Mode.............

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 Excel MVP - XL97 SR2 & XL2002

 

[Pierre Leclerc]

Hi

Go to Tools/Options/Calculation and make sure that the automatic
calculation is checked.

find other interesting tips at:
http://www.excel-vba.com

I have no idea what option I pressed, but no formula on
any of my spreadsheets is calculating by itself. I have
to click on the cell, press F2 and hit enter in order to
perform the operation.

ANY IDEAS???? GOING BANANAS !!

Thanks !!
-xavier

Pierre Leclerc
http://www.excel-vba.com
(e-mail address removed)