I'm using about 100 3D pdf instruction files that are automatically linked in
a spreadsheet. The spreadsheet is small, but the instructions are large.
And the spreadsheet gets copied from project to project (folder to folder).
I don't want to clutter the server with these instructions plus when I'm
updating the instructions, I only want to do it once so everyone has access
to them instantly.

Is there any way to make the hyperlink function relative? In other words,
when I click on it, it will go to the root directory of the drive where the
current file is (p:\) and the up to a set location (P:\Instructions)? It
shouldn't matter how many folders deep the current file is. It just needs to
go up to the top and then down from there. And it can't matter what
different users name the drive, plus there are multiple servers in different
offices, so the root directory name will be variable.

Maybe this is too much for this site to handle, but I thought I would try.

Thanks!