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..
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.
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:
Post a Comment