Formmulas are not appling in the excel of office...

Question

i was working with excel sheet for a long ago with my R and Ds suddenly it prompted for a error by mistake i clicked yes, from that time i am not able to put the formulas in any of my excel files unless i change the value and save it.Plz help me.regards,chidambar