Hi

You can use INDIRECT to compose the cell/range references - so long as all
source workbooks are opened along with your workbook. When the latter isn't
an option, you have to use some UDF (from time to time a link which provides
one appears in Excel NG's), or some VBA procedure to rewrite formulas
accordingly your files list.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"HughT" wrote in message
...
I have a folder with 12 excel files. The first one in the range has a list
of
filenames that I need to link to to retrieve specific data. How can I
create
a link to external xls files using the filenames in COL F in the first
file?