Nov 04 2020 12:07 PM
I have a template folder containg two files that are linked together:
When I copy this folder, the newly created Word document will keep its links to the original Excel file. Is there any way I can prevent this by creating a relative link to "Report data.xlsx" in the current folder?
Just for reference: more info about "Edit Links to Files"
Nov 04 2020 12:51 PM
SolutionFound the answer after som further research. For graphs copied from Excel to Word (Links to Files), relative linking can be achieved by VBA macro.
For anyone else wondering, see the bottom of this thread: https://www.msofficeforums.com/word/38722-word-fields-relative-paths-external-files.html
Nov 04 2020 12:51 PM
SolutionFound the answer after som further research. For graphs copied from Excel to Word (Links to Files), relative linking can be achieved by VBA macro.
For anyone else wondering, see the bottom of this thread: https://www.msofficeforums.com/word/38722-word-fields-relative-paths-external-files.html