Automatic update of cell values not working.....

[tnuis]

Hello,

I´m experiencing the darnest thing, all of the sudden all of mye =SUM fomulas and References to other cells doe not work anymore. And this is for 7 sheets full of them.

For them to work I now have to click on the cell, and then click on the formula bar and then hit ENTER.

In other Words, it seems that something is missing so that none of the formulas are triggering.

If anybody know anything about this problem, and most important, a solution then please let me know.

[abubaniyan]

I EXCEL OPTIOns you will find the formula tab
in that workbook calculation is there...
select automatic in that......

[tnuis]

I EXCEL OPTIOns you will find the formula tab
in that workbook calculation is there...
select automatic in that......

Waou that simple huh?

Thanks a lot man, that did the trick. You saved my day


Do you however know why this suddenly happened?

[abubaniyan]

ITS A SYSTEM ERROR, MAY HAPPEn SOMETIMES...HAPPY TO HELP OLWAYZZZZ......!