static formulas - HELP
 

All of sudden formulas in ALL my files do not calculate when I change a
number????????? Ideas (solutions) please.

static formulas - HELP
 

One likely cause is the calc mode's set to manual.
Click Tools Options Calculation tab. Ensure auto is checked OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Henry" wrote:
All of sudden formulas in ALL my files do not calculate when I change a
number????????? Ideas (solutions) please.

static formulas - HELP
 

Your my hero!
(any idea why would it randomly switch to manual?)

"Max" wrote:

One likely cause is the calc mode's set to manual.
Click Tools Options Calculation tab. Ensure auto is checked OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Henry" wrote:
All of sudden formulas in ALL my files do not calculate when I change a
number????????? Ideas (solutions) please.

static formulas - HELP
 

(any idea why would it randomly switch to manual?)

Excel sets the session's calc mode based on the mode of the 1st workbook
that's opened. If the 1st book's saved mode happen to be manual, then it's
manual mode. And any subsequent book(s) that's opened within the same Excel
session (irrespective of their earlier saved calc modes) will "take-on" this
manual mode, and if saved thereafter would be saved on manual mode.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Henry" wrote in message
...
Your my hero!
(any idea why would it randomly switch to manual?)