I’m working with Office365.

I have Made a Word-template with spreadsheets of a linked Excel file. Both files have the same name and located in the same folder. I use this template for several projects.

So I copy both files in a new folder and rename them.
This is when the problems start.
The linked spreadsheets are not anymore linked to the new Excel file, but to the original Excel file.

Years ago there was some code in both documents that linked two files, even when you copied both files Or renamed them, but I can’t find how this worked.

So if someone has a solution for this, please.

Greetz Paul