Changing source file using paste link

Originally Posted by 6StringJazzer

I have tried to do this in the past and have found no way to directly edit existing links in bulk without having to re-paste them all.

I have had success with this method:

1. Make sure the Word file and both Excel files are closed.
2. Rename the original Excel file to something else.
3. Rename the new Excel file to the original name (the one used in the Word links).
4. Open the new Excel file.
5. Open the Word file. The Word file should now show data from the new Excel file.
6. While the Word file is still open, save the new Excel file using the new name.
7. The links in the Word file should now reflect the new Excel file name.

Please let us know if that works for you.

That did work thanks.

The trouble is, I need to be able to move the word and excel documents to a different file. However, if I move the excel and word document into a different file the links all break. Is there a way around this?