Hi all,
I have two excels test1 and test2 (Excel 2010 version) on a networked drive and cell A1 in test1 is linked to the value in test2's A1 cell. If I have the two excels open on two separate PCs, how do I get test1 to reflect a change made to test2 on the 2nd PC immediately? Is there anyway to do this, or can someone help provide clean code that automatically refreshes all excel links on test1 after 30secs? Thanks in advance..Appreciate it.