Can anyone tell me if there is a way to link to cells in another spreadsheet without having to open that spreadsheet up each time.
For example if I have two spreadsheet files (FILE1.XLS and FILE2.XLS), and I have a VLOOKUP command in FILE2.XLS that points to cells within FILE1.XLS - do I always have to open FILE1.XLS first to be able to read the contents.
=VLOOKUP(C6,[FILE1.xls]Sheet1!$B$3:$C$6,2,FALSE)
It's a pain to keep having to open the FILE1.XLS first before the formula will work in FILE2.XLS
Thanks
For example if I have two spreadsheet files (FILE1.XLS and FILE2.XLS), and I have a VLOOKUP command in FILE2.XLS that points to cells within FILE1.XLS - do I always have to open FILE1.XLS first to be able to read the contents.
=VLOOKUP(C6,[FILE1.xls]Sheet1!$B$3:$C$6,2,FALSE)
It's a pain to keep having to open the FILE1.XLS first before the formula will work in FILE2.XLS
Thanks