I have an Excel file that I use to manually input values from many files. Those files are then linked to the values, so that if I want to see more information I can click on the value to open the file.
However this system of linking is fragile. If I move a file or decide to redesign the folder structure, the link breaks. Is there a way to dynamically keep those links updated so that if I move a file, its link will keep track of it and update to where it has been moved to?