The easiest way.

With both workbooks open, type "=" in the cell you want to contain the
reference.

Switch to the target workbook and click in the cell that you want to
reference. The formula bar will now have something like

=[CompletelyDifferent.xls]Sheet1!A1

Type Enter. XL switches back to the first workbook.

You can now close the other workbook - XL will then display the path as
well as the file name in the reference.

Of course, you could type in the reference directly, now that you've
seen the format.

In article ,
"Chuck" wrote:

How to you get one cell in a workbook to equal another cell in a completely
different workbook?