Sometime you may see that your excel is not updating it’s cells values or excel formulas are not updating when dragging. You may be big surprised on that. Actually it’s not a big deal for you, if you follow the below steps:
- Go to Formulas-> Calculation Options
- Set Automatic instead of Manual
Now you have understood that somehow your workbook has been selected “Manual” instead of “Automatic” in “Calculation Options” section under Formulas tab.
Hope you have enjoyed our tips. If you have any query related to this writeup, please feel free to write your comments on our facebook page. If you want to get updated, you can subscribe our facebook page http://www.facebook.com/freetechtrainer.