Excel Question

[Sgt-Peppa]

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

[zaza]

You don't need the full path if the file you're linking to is in the same folder (or a subfolder) of the file you're working in. You can just use the name and it can find it. Otherwise, not that I'm aware of.

BTW, you might want to get this moved to the Office forum...


zaza