Ampler toggles Excel between automatic and manual calculation from a dropdown, so you can pause recalculation on a heavy model without digging through File → Options.
Quick answer: Toggle between Automatic and Manual calculation from the Ampler dropdown; press Shift+F9 to recalculate when in manual mode.
How to use it
Toggle Automatic or Manual calculation from the dropdown.
- Toggle between Automatic and Manual calculation from the dropdown menu.
- In manual mode, press Shift+F9 to recalculate when you’re ready.
This avoids going through File → Options → Formulas to change the calculation setting.
Keyboard shortcut
Shift+F9 recalculates in manual mode. Ampler functions can be assigned shortcuts in Settings → Shortcuts.
Why use it
A large model recalculates on every edit, which makes it slow to work in. Switching to manual calculation pauses that, so you can make a series of changes and recalculate once — and Ampler puts the toggle a click away instead of buried in Options.
How consultants use it
Big models are slow when every keystroke triggers a full recalculation, so switching to manual is a standard modelling move. Three habits apply:
- Manual on heavy models: recalculation is paused so editing stays responsive.
- Recalculate deliberately: Shift+F9 refreshes the model when you’re ready.
- Back to automatic: the toggle makes switching back quick, so results aren’t left stale.
A one-click calculation toggle keeps a heavy model responsive.
Tips & best practices
- Switch to manual before a run of edits on a large model.
- Press Shift+F9 to recalculate the sheet, or F9 for the whole workbook.
- Switch back to automatic so final results aren’t stale.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you switch Excel to manual calculation?
Toggle to Manual from the Ampler calculation dropdown — no need to go through File → Options → Formulas.
How do you recalculate in manual mode?
Press Shift+F9 to recalculate the active sheet (or F9 for the whole workbook).
Why switch off automatic calculation in Excel?
A large model recalculates on every edit and becomes slow. Manual calculation pauses that so you can edit responsively and recalculate when ready.