How to Change Formula Calculation Options in Excel
By default, Excel calculates all formulas instantaneously when they are entered in a worksheet. You can, however, change the calculation options so that formulas will only calculate when directed by you. If you have large sheets of data and multiple formulas trying to calculate at once, it can take a while for all the calculations to update. If that’s the case, you’ll want to update this setting.