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

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

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

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

solution was provided in the earlier post, if it doesn't
works, you need to respond back on why its not working so that
we can look at it again instead of a new post

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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