*talks uncomfortably loudly over booming party music*

Hi guys! Thanks for coming, good to see you.

I've got a banging set of excel questions in, it's gonna be MAAAASSIVE! Let's get proper fucking stuck in to it dawgs.

When you have a formula in Excel File 1 (EF1) that links to a cell in Excel File 2 (EF2 - a completely separate file, man!), and then you update EF2 so that the cell in question moves (let's say from A1 to A2, for a laugh) the formula in EF1 doesn't automatically update! I KNOW!

Is there any way round this problem? Perhaps mumsnet can help?