I came across this strange problem where all of a sudden my excel sheet suddenly stopped calculating the formulas on its own. I had to click the "Save" button to make excel do the calculations.
Normally, I enter a value in a cell and expect the value in another cell to be automatically updated based on the formula present in it. It was frustrating to find that this suddenly stopped working !!!
A simple google gave me this link.
http://www.techsupportforum.com/microsoft-support/microsoft-office-support/163598-solved-excel-formula-not-updating.html
And it saved my day :)
Pressing F9 would make excel do the calculations without me clicking on "Save" button.
But, an even better thing was to change the setting under Tools-> Options-> Calculations to "Automatic" .. and vroom the calculations starting getting updated "automatically" as earlier.
I have no idea how I ended up in this but seeing it work back make my day !!!
No comments:
Post a Comment