Thursday, July 29, 2010

excel 2003 formulas not working

when excel formulas suddenly stops working, the only place you have to see is excel options, to do this follow these steps,

  1. open excel 2003
  2. click tools, then click options
  3. in the opened window, click calculation tab
  4. in there check under calculation, if your calculation mode set to manual, change it back to automatic mode.
  5. after change click ok
  6. now check your excel work sheet, the formulas work correctly.
**these settings may apply similar way in office 2007**

No comments:

Post a Comment