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. When someone tells you that formulas aren’t calculating, it’s probably because the Calculation setting has been changed to Manual, instead of Automatic.Even more mysterious, the calculations worked fine on some machines, but not others. That can happen if the first workbook that you open in an Excel session was saved as Manual calculation.If you’re new to Power Query, chances are you’re more comfortable doing tricky mathematics using Excel formulas, rather that Power Query formulas.
You may want to temporarily turn off automatic calculation to save time until you are finished entering and changing the formulas in your worksheet. NOTE: If you don’t want to turn off the automatic calculation feature, and you have multiple processors in your computer, you can turn on the multi-threading feature, which could speed up the recalculation of your formulas by a little bit, depending on how many processors your computer has.However, if you want to set the iteration options, you must use the Formulas page on the Word Options dialog box.Excel 2013 has a multi-threading feature that allows you to reduce the time it takes to calculate complex formulas.But in this table, we added a new column called “Est” to the end, which holds the following formula: =[@Price]*[@Quantity] So far so good, but what happens when we add a new line to our Animals table and refresh it? The fix is remarkably simple, once you know what to do: Now, at this point, nothing appears to change.In fact, even refreshing the table seems to make no difference.
Naturally, that means that Excel won’t auto-fill the formula, as it doesn’t know which is correct (the formulas or the blank cell.) We need to fix that before this will work for us. And if your behavior is different, I’d love to know.