create link for a tab from one workbook to a cell on another workbook

Copper Contributor



Can you inform me the correct way to link a tab in one workbook to a cell in a different workbook please 

3 Replies


The easiest way:

  • Open both workbooks.
  • Select the cell where you want the link.
  • Type =
  • Switch to the other workbook, activate the correct sheet, then click on the cell you want to link to.
  • Press Enter.
  • Switch to the other workbook again, and close it (saving it if necessary).
  • Finally, save the workbook with the link formula.

If you now look at the formula, you'll see its syntax:



Click on the sheet tab of the worksheet that contains the cell that you want to link to.