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