Hi all,

if am trying to link two Excel Files together.

Say File1 has a Table1 which contains a Value of 10 in Space A1
In File2 in Table1 I want to see the value of File1/Table1/A1

So I write this in my Value Filed A1 of File2 :
='D:\myFiles\ExcelTest\File2\[File2.xls]Table1'!$A1

This works and it shows me the value 10.

Is there any way in Excel that I can write that without the absolute Path?
For example like this:
='..\File2\[File2.xls]Table1'!$A1

This would enable that the Structure could be moved for example to
D:\myOtherFiles\

Did I explain that OK?

Thanks,

Stephan