- open excel 2003
- click tools, then click options
- in the opened window, click calculation tab
- in there check under calculation, if your calculation mode set to manual, change it back to automatic mode.
- after change click ok
- now check your excel work sheet, the formulas work correctly.
Thursday, July 29, 2010
when excel formulas suddenly stops working, the only place you have to see is excel options, to do this follow these steps,