View Single Post
  #2   Report Post  
Mladen_Dj
 
Posts: n/a
Default Can i change multiple hyperlinks at once


"Magser" wrote in message
...
I have a large database of files that are hyperlinked in a File Register
created in excel. All of these files have now been moved to a different
drive, but the folder names etc are the same. Is there a quick way to
change
the path of the hyperlink, as to do each one individually would take
weeks.


Just go to Edit-Replace, and choose part of path which was changed (for
example C:\), and write it in "Find what:" box, than put new patcial path in
"Replace with" box (for example D:\). unselect "Match entire cell
contents:" if it is selected, and click "Replace all".