I want to create a workbook which reads the value from a particular named
range (Test) in a number of workbooks.

The actual formula is:

='Y:\Testing\TestSource001.xls'!Test

I would like to build this formula and then read the value using the
Indirect function but cannot seem to get Indirect to work on anything other
than on a worksheet level.

Does Indirect work for external links? I can find nothing which says it has
this limitation, but I cannot find any examples of external links.

Paul Smith