How to Link 2 Excel Spreadsheets. You can establish links across multiple spreadsheets and workbooks in Microsoft Excel to streamline data management.

In Excel 2003, click the 1904 Date System option. Click OK. When you copy data between two workbooks that use different systems, you’ll run into shifting dates.