To check the setting, click the Formulas tab on the Excel Ribbon, and click the Calculate Options drop down. ![]() In this case, the workbook calculation was set to Automatic on all the machines – that’s the first thing we checked. That setting affects all the other workbooks the you open during that session. That can happen if the first workbook that you open in an Excel session was saved as Manual calculation. When someone complains about Excel formulas not calculating, it’s usually because the Calculation setting has been changed to Manual, instead of Automatic. Hint: It wasn’t one of the obvious solutions. Why are Excel formulas not calculating on some computers? Even more mysterious, the calculations worked fine on some machines, but not others. What happens when good Excel formulas go bad? A workbook of mine that worked fine for several years, when using Excel 2003, suddenly refused to update all the formulas, after a switch to Excel 2010.
0 Comments
Leave a Reply. |