Keeping linked sheets relative... help!

[Gaijintendo]

I am linking to external sheets but as soon as I enter
[FileName.xls]SheetName!A1
it resolves it to something like
='Macintosh:Users:MyNameesktop:[FileName.xls]SheetName'!A1
Which is fair enough - that IS what I am referring to - but I want it to
Stay Relative.

Why? Because I would like to use this file as a template, and plop it in
lots of different folders - and see the data be gathered from other files -
so basically - I don't want Excel to fix the links!

Any suggestions. I am working with Excel 2008 but I assume it is much the
same on PC versions of Excel.

 

[Gaijintendo]

It occurs to me I can use INDIRECT and have the sheet name and filename
generated on the fly...

 

[Spiky]

It occurs to me I can use INDIRECT and have the sheet name and filename
generated on the fly...

This would be much better since Excel stores the complete path of the
filename and it is not dynamic, even on a Mac, which has a better
filing system than that available. (I assume this hasn't changed with
v2008) With your first post, the answer would be to Change Link Source
with each new file combo that you make, which might prove tiresome. If
you can make INDIRECT get the names correct for you, that would likely
be a lot smoother.