MS Excel - Formula auto calculations not working

Issue: 
Ms Excel - Formula auto calculations not working / Values are updated only when the document is Saved or Closed

O/S:
Windows

Solution / Workaround:

Looks like the Calculation option is changed somehow.
  1. Go to "Formulas" tab
  2. Click on "Calculation Options"
  3. Choose the option you want --> "Automatic" 

Comments