Hyperlinks in Excel

[jenno]

We put hyperlinks in our Excel files to other excel, word, and adobe files. At the end of each year, we move ALL of our files from that year into a specific year folder, but this breaks all of our hyperlinks since we are moving the hyperlink files. Is there any way to keep the integrity of the hyperlinks when we move all of our files? Is there maybe even a program out there that can help?

Thanks for your help!

 

[yeheya]

I got a idea which can help.

Code a macro to add Hyperlink, based on the current workbook path, in the Workbook OPEN even.

Regards,
Yeheya

 

[nbrcrunch]

Suggestions:

1. Don't archive at the end, archive immediately. You already know you are going to putting things into annual folders. Go ahead and create those folders ahead of time (at least at the beginning of each year). Then you don't have to worry about broken links.

2. Use the hyperlink function along with concatenated strings. Use a separate cell to indicate the path of the stored documents then reference that cell in the hyperlink function. As paths change, edit just the one cell and all your hyperlinks will change accordingly.