Excel as document navigation

[spartans]

Dear all,

I need some help. I am developing a GANTT Chart in Excel. At the same time, I would like to use it as document navigator as well. So I can put external link to document files in the excel and people can just click on it and open the document.

This is not a problem and I did it already. The problem is that I will need to send a folder that contains the excel file and all the documents linked to it to people.

Therefore, I will need it to update it automatically and anchor the link only to the main folder, without referencing to my hard drive.

Is this even possible? Thanks in advance for any of your suggestion!

Cheers!

[spartans]

I apologize for this. It seems like I solved the problem my self (to put all the files in the same folder or sub-folders). Thanks.