"Mladen_Dj" <mister.gjuro@gmail.com> wrote in message
news:djlk0h$q3g$1@sunce.iskon.hr...
>
> "Magser" <Magser@discussions.microsoft.com> wrote in message
> news:147026A1-4B73-4509-B094-14E0E3E2107F@microsoft.com...
>>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".
>
Huh, its seems not work , because excel don't change path but only text in
the cell. Then you can use formula, for example if hyperlinks are in column
A, put in B1 "=HYPERLINK("D"&RIGHT(A1,LEN(A1)-1))" where D is drive letter
which is changed, and then copy formula to the end of file list. Sorry for
the previous wrong tip.