Microsoft Excel Not Updating formulas automatically

Many times we see this problem.
Excel doesn't update the formula values automatically. To make it work We need to manually open formula and press enter.

How to Solve this problem.
1. Check the formulas are correct or not
Press Ctrl + ` to see all formulas ( Again press Ctrl + `) to see normal screen.

2. Follow the below steps to set the formulas to update automatically

Goto File - Excel Options..

Goto - Formulas Tab and Select 'Automatic' Radio button and Press OK

That's it you are done.

Now try changing the values of the cells and check if the formula cell is updating its values automatically.

No comments: