Hello guys,

is it possible to get a behaviour like this in Excel?

A1 contains a text value ='C:\[file.xls]List1'!D51 (not a formula!)
A2 contains a reference to A1 so that it actually displays D51 in
external file.xls

I thought INDIRECT would be my choice but it does not work with
external files.

Any ideas?

Cheers,

-- joe