I am linking to external sheets but as soon as I enter
[FileName.xls]SheetName!A1
it resolves it to something like
='Macintosh:Users:MyName:Desktop:[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.