Windows 10 and Excel Spreadsheets????
I'm now on Windows 10 and trying to figure out a problem with Microsoft Excel spreadsheets. Everything was working fine last week. Now a problem has shown up, here's what is happening. I put a nu...
Forum Discussion
bwanshoom wrote:
Not sure what version of Excel you have, but check your settings. On Excel 2010 & 2013:
File > Options > Formulas > Workbook Calculation > Automatic.
You can also manually update the formulas by pressing F9.
Although I've been out of the game for the last 2 years, when I was doing tech support, this was a very common issue, no matter what version of Excel. Bwanshoom gives the correct answer as to how to resolve the problem. Here's a link with a more detailed description/solution for later versions of Office:
https://www.emagenit.com/Functions/how-to-turn-off-on-excels-calculation-mode.htm
I always blamed it on users who were a bit click happy - moving a little too fast and accidentally disabling calculation, when they meant to do something else.
