By default Excel will automatically calculate any formula that you type in or insert into it. That’s what you want it to do right?. Most times yes. You can however change that default setting to only recalculate when you instruct it to. This I find useful if I have a larger spreadsheet or some particularly hefty calculations.
Turning to manual calculations lets you decide when Excel will update. To enable manual calculations
- Office Button
- Excel Options
- Formulas Tab
- Calculation Options
- Select Manual
- Hit Ok
To recalculate the workbook press F9, there are few options with this….
Calculates formulas since the last calculation in all of your open workbooks
Calculates formulas that have changed since the last calculation just in the active worksheet
Calculates all formulas in all open workbooks regardless of when they were last calculated