To continue the theme from yesterday and Monday, there’s another recalculate option — mostly useful if you have a spreadsheet that seems to have been corrupted and you want to check all the formulas. Press Ctrl+Alt+F9 to do the following:
Calculates all formulas in all open workbooks, regardless of whether they have changed since last time or not.