Rename Folder Breaks Excel Links
- Thread starter doggs
- Start date
You could change the link to be a relative path by referencing the parent folder. So e.g if all the files are in c:\blah then
c:\blah\file.xlsx
would become
./file.xlsx
Obviously if you already have a bunch of files then you'd have to update the paths anyway, but it would be a one-off in case they were to be moved again.
Another alternative outside of Excel would be to use "mklink" to repoint the old location to the new location - although I'd only do this if the old location is no longer in use for other files and obviously it would only work for your PC in case others are accessing the files.
c:\blah\file.xlsx
would become
./file.xlsx
Obviously if you already have a bunch of files then you'd have to update the paths anyway, but it would be a one-off in case they were to be moved again.
Another alternative outside of Excel would be to use "mklink" to repoint the old location to the new location - although I'd only do this if the old location is no longer in use for other files and obviously it would only work for your PC in case others are accessing the files.