Can I refer to links relationally in Excel?

[yalamo]

I use Excel 2000 on WINXP SP3.

I have a whole bunch of Excel files in subdirectories of a directory I call D:\ExcelData. These contain Excel files with cells that have links to files in this directory, but not necessarily to the same subdirectory, so that the cell formula might look something like:
"D:\ExcelData\SubDirectory1\SubsubDirectory2\[ExcelFileA.xls]A1"
where ExcelFileA is the file I want to link to.

This works fine, and I've been using it for a few years, but now, I want to copy this directory onto a flash memory stick. I want to take this with me when I travel, instead of a laptop. However, when I will insert the memory stick into another PC, the directory will be called "F:\ExcelData" (or G or H), and I'll have to spend a lot of time finding each of the links to correct for this.

My question is this: Is there any way I can refer to the main directory in a relational manner without specifically stating the drive letter, to save me the cumbersome procedure of searching for each link?

 

[GlennUK]

Excel links are naturally relative, so that if you copy the whole directory and subdirectories the links will work fine.

The relativaty works for links that are in the same folder as the master report, and for subdirectories below that folder. It does not work if the subdirectories are below a different folder on the disk.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[yalamo]

Thanks GlennUK, but are you sure? The formulas in the cells specifically state "D:\ExcelData\..." and the drive letter of the memory stick will not be D. If you're right, I have nothing to worry about, but how does Excel know not to look for Drive D in that case?

 

[GlennUK]

Yes, I am sure!

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[yalamo]

Thanks again, GlennUK. You are absolutely correct!