Here is our video guide on excel calculation options. You can alternatively use the F9 shortcut key to refresh the workbook. Head over to Formulas → Calculation → Click on Calculate now/Calculate Sheet option. If you haven’t done that then you will end up with incorrect results. Once you are done, you need to click on Save or Refresh workbook to recalculate. If you turn this option ‘ ON‘ then your formulas will not be updated automatically, this in turn increase spreadsheet processing speed. But there are instances where you might have turned that to ‘m anual‘ to speed up the process.
