What you press | What you get |
---|---|
F9 | Calculates formulas that have changed since the last calculation, in all open workbooks. |
Shift+F9 | Calculates formulas that have changed since the last calculation, just in the active worksheet. |
Ctrl+Alt+F9 | Calculates all formulas in all open workbooks, regardless of when they were last calculated |