Today I’ve experienced, again, the problem with Excel that it was calculating formulas only after clicking save, not while entering data. As it was pretty annoying I’ve googled the solution, it was for some ancient version of Excel, but I was able to adjust it to 2010 version. Here you go:
1. Go to **Formulas **-> Calculation Options.
2. Set it to Automatic.
It switches to manual if you open Excel file where somebody set it like that. Why people are doing it, I don’t know. Enjoy!