*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?