I would imagine this is fairly simple, but have had no luck unfortunately.
I have two excel files saved on the network. Test1.xls and Test2.xls. Test1 is the source and test2 is the destination.
When i update a cell in test1, this cell is referenced in test2 - so anybody who opens...