I have a Word document with approximately 70 links to various tables in Excel. And I know how toggle F9 to do a global search and replace on the file name nad path to change all the links relatively quickly.



Unfortunately, there are others in my office that are not as strong in Excel and Word and just can't grasp that concept.

The other way I know to change all the links is via Prepare | Edit links to files. But my issue seems to be that after I selected all the links and choose change source, the dialog change source box always defaults to old the file location, and does not stay in the current directory. Thus, I need to navigate up/down a number of directories to choose the correct file each time.

Would anyone know how to ensure when changing the links, the open/change source dialog box does not look to the old folder path all the time, and just stays in the current directory?