"Biff" wrote...
A couple of things:

datajoe.xls!N6

You don't specify the sheet name.

If these were all single worksheet Excel 2.x/3.x workbooks (or later
workbooks with a single worksheet with the same name as the base filename
without the .xls extension), then datajoe.xls!N6 is a valid external
reference.