On Thu, 1 Nov 2007 11:17:01 -0700, Angyl
wrote:

No, there isn't. You can use RagDyer's suggestion to combine the sheets into a
single workbook. If you don't do that, then the user will have to put the
files in whatever directory they choose, then open the book with the links and
go to Edit/Links to correct the path to the linked workbook.

So is there a way to get Excel to look for a file RELATIVE to its current
location (like the same directory) rather than at a full FIXED PATH?