Have you tried Find and Replace All...(which will replace all the paths in
one click)
--
If this post helps click Yes
---------------
Jacob Skaria


"AskExcel" wrote:

Hi,
no, it doesn't help.
i mean the link is where i put a = sign and click on source cell. so
whenever there is a change in source cell, the cell will get updated.
but now when there is a change of the path of source file, i need to change
it via edit link.
so i would like to know if there is any better way to change the path easily.
in the worksheet, i have many cells linking to many source file.

thanks



"Jacob Skaria" wrote:

Please find the below example. Copy the formula to the other rows

A1 = C:\sample.jpg (hyperlink)
B1 = D:\temp\ (new path)
C1 = HYPERLINK(SUBSTITUTE(A1,"C:\",B1))


If this post helps click Yes
---------------
Jacob Skaria


"AskExcel" wrote:

hi,
i have excel sheet with link cell to many source of excel sheet.
when the source changed path, i need to manually change it via edit link
under data menu.
may i know if there is any easier way to change once instead of change it 1
by 1.
if macro can achieve this, how?
need advice.
thanks