Ctrl+Shift+Alt+F9: Calculate all formulas and dependent formulas

To finish the options for F9, let’s suppose you really need Excel to double-check EVERY formula to make sure the numbers are right (again, probably only useful if you’ve opened a bunch of workbooks that are huge, manually calculated, and may have been corrupted). Press Ctrl+Shift+Alt+F9 to do this:

Rechecks dependent formulas, and then calculates all formulas in all open workbooks, regardless of whether they have changed since last time or not.

I’ve done this before with a spreadsheet that had six dependent files, 60,000 rows and over 100 columns of complex formulas — it wasn’t done until after I came back from lunch.

2 thoughts on “Ctrl+Shift+Alt+F9: Calculate all formulas and dependent formulas”

  1. Hi, I received a file that requires alt+ctrl+f9 even tough no other workbooks need to be open. However there are dependent workbooks. And yet , the alt+ctrl+f9 shortcut is essential for this workbook to calculate properly. The designer instructed us to do alt+ctrl+f9 and then f9. Does that make sense to you?

Leave a Reply

Your email address will not be published. Required fields are marked *