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.
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?
this formula is not applying why are you playing with the innocent hearts.
This is totally fake.
And what happens if you press Ctrl-Alt-F9 (calculateFull) or Ctrl-Alt-Shift-F9 (rebuild dependency trees then full calculate)? Charles Williams Sep 15 ’15 at 16:10