Subscribe (via Feedburner)
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.
on March 7th, 2009 at 1:38 am
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?
on February 5th, 2013 at 5:27 am
this formula is not applying why are you playing with the innocent hearts.
This is totally fake.