all formula's not working

[HYKE]

Hi All,

For some I can't comprehend, all formulas in my excel sheet stopped working. It will only worked once I press F2, move the cursor to the equal sign and press enter. now this is freaking me out as I do not know what's happening...Can somebody advise me on how to fix this?

Thanks...

 

[Robert Mika]

Is thi only this spreadsheet?
Maybe the "Manuall calcualtions" option is switch on?
Are you seeing your formula in the cell? You maiht changed your format to Text.

 

[HYKE]

Hi Robert,

You're a genius...... All my formula's finally worked! I was doing the F2+enter on every cell with formula all day long yesterday. How did that manual button got selected (i don't know) I think I will have to find out who the culprit was...Anyhow, thanks tonsssss!!!!!!!!!!

 

[Robert Mika]

If you are working in Ex07 or Ex10 not that hard to select.
I'm using this button all the time and found out that this is one of the best feature in Excel.

 

[HYKE]

sad to say at work we still use excel 2003. I am still not quite familiar with 07 and have not seen excel 2010. I guess I will have to start looking at excel 2010 now...