1. Make sure both workbooks (files) are open.
  2. Select where the formula will go, press =.
  3. Using the Window menu, switch to the source workbook.
  4. Select the cell you want linked in.
  5. Press ENTER.