hyperlink base

[cedmunds]

Hello,
I have a three tier file Hyperlinking question.
I have a parent Excel 2007 workbook which has many Hyperlinks to what I will call a set of child workbook files. In the child workbook files there are also hyperlinks to another set of files.

In the parent workbook I have created the Hyperlinks to the child files using a Hyperlink Base which works great for linking from the parent to the first set of child files.

The problem I have is that the 1st set of child files needs to somehow inherit or set their hyperlink base to that of the parent file that opened them so that the links in the child files with use the same hyperlink base to open the next set of child files.

Anyone know how I can get an Excel 2007 workbook to inherit or set its hyperlink base to the the parent file that opened it? Very confusing.

The real problem here is that anyone can download these file sets to their local drive from a server to any location on their local drive. I only want them to have to go to the parent file and set the hyperlink base in that one file to be able to have working hyperlinks to all of the other files parent to child. Very confusing. Anyway to do this?

 

[Andrew Poulsom]

What's the folder structure? You can include the subfolder in the hyperlink address. The rest of the path will be relative to that of the workbook that contains the hyperlink. That way there's no need to set a hyperlink base.