•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#excel
#files
#network share
#links
#path
#automation
#update
#external files
#re-saving
#file
#change
#new path
#issue
#easier
#thousands
#hundreds
#re-save