how to change the link in excel easily
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
|