I have lots of formulas that reference other spreadsheets but they won't update (even when I hit F9) until I open each spreadsheet that it is referencing. Any Quicker way to do this? 


=VLOOKUP($C12,'[SA Overview 28.xlsx]MTD Numbers'!$A:$O,5,FALSE)