Forum Discussion
How do I make a hyperlink follow a moved file?
I guess there is no way to create such a dynamic link that recognizes a moved file or folder. This reason is easy: The Excel formula does not have a clue what you are doing on your file structure on the hard drive.
Even if you would use a nested HYPERLINK function (e.g. with IFS or ISERROR) it would give in error once the file is moved.
The only way that might work is a VBA solution, but this would be very specific based on your environment and requirments.
Martin_Weiss Thanks for your thoughts. I rather suspected this was the case, as I can logically follow the process through.
I was thinking how nice it is that if you move a cell within a sheet, the formulas will update any references to the moved cell.
I was hoping there was a way to extend this process beyond the sheet at hand.
I can't spend a large amount of time on it, it's already a lot of work maintaining the sheet as new projects come in and old ones complete. All I can think of is nesting some IFS statements to point at different directories based on the content of a cell used to indicate the project status. Again, a lot of work.
Thanks.