You can establish links across multiple spreadsheets and workbooks in Microsoft Excel to streamline data management. A link enables a cell in one spreadsheet – the destination spreadsheet – to reference or obtain information from a cell in another spreadsheet – the source spreadsheet.

How do I link two Excel workbooks?

Select the cell or cells where you want to create the external reference. Type = (equal sign). Switch to the source workbook, and then click the worksheet that contains the cells that you want to link. Press F3, select the name that you want to link to and press Enter.

Can you link data from one Excel spreadsheet to another?

Link Spreadsheet Cells with !

To reference a cell from one sheet in another, all you need to know is the sheet's name and the cell's name. Link them together with an exclamation mark. ... Type = in your cell, then click the other sheet and select the cell you want, and press enter.