•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Upadate Links Across many files?
Hello, I have an issue at work that I am hoping to automate as much as possible. I have hundreds (possibly thousands) of excel files that contain links to external files on a network share. All have the same path and I want to change to a new path. (e.g. X:\FILES\001.xlsx to X:\NEWFILES\001.xlsx)
Is there a way to do this easier than just opening each file, updating the path and re-saving?
Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site