I have several linked workbooks in various folders, some of which have the same names. I want to move them all into the same folder, make the names unique where necessary, and automatically update the links. The simplest way I can think of is: In Windows, move [and rename) each workbook into the target folder for each new moved workbook: edit the links to reflect the new names and folder save it back into the new folder. I need to do this for several sets of applications. Can anyone suggest a faster, easier, procedure?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Moving or renaming linked workbooks

Thread starter hershmab
Start date Nov 9, 2014
Tags

links between workbooks move workbooks rename book

hershmab

New Member

Nov 9, 2014

I have several linked workbooks in various folders, some of which have the same names. I want to move them all into the same folder, make the names unique where necessary, and automatically update the links.

The simplest way I can think of is:

In Windows, move [and rename) each workbook into the target folder
for each new moved workbook:
1. edit the links to reflect the new names and folder
2. save it back into the new folder.

I need to do this for several sets of applications. Can anyone suggest a faster, easier, procedure?