If you want to link data between Excel workbooks stored on a hard disk without needing to open both workbooks simultaneously, it's not directly possible with standard Excel functionality. Excel requires access to the source workbook to establish and maintain the links between wor...