Excel is not updating calculations
Even if the Calculation option is set for Manual, you can use a Ribbon command or keyboard shortcut to force a calculation.
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.When I insert a row in Excel and copy formulas from row above, the cell reference in 'Opening Stock' does not update automatically in the row after the new blank row (should be equal to previous row balance, which is 60 now). Is there a way to force Excel to update cell reference to the cell in blank row above?Have searched the web, but did not get any satisfactory answer.Our guide below will show you how to revert back to automatic calculations if your workbook is currently set to update only through manual intervention.The steps in this article are going to show you how to re-enable the setting in your Excel 2013 worksheet which makes your formulas update automatically.