I have a cell or cells that have a link to an external file/workbook on my
drive.

I have changed the path that it was kept in and I know I have the option to
update the data when opening the file but I also want to be able to select a
specific cell and adjust VIA a window / wizard rather than trying to type in
the new link.

Can this be done??

Mike