how to change the link in excel easily

  • Thread starter Thread starter AskExcel
  • Start date Start date
A

AskExcel

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
 
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
 
Have you tried Find and Replace All...(which will replace all the paths in
one click)
 
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
 
Back
Top