SOLVED

Microsoft Word: "Edit Links to Files": create relative link

%3CLINGO-SUB%20id%3D%22lingo-sub-1854670%22%20slang%3D%22en-US%22%3EMicrosoft%20Word%3A%20%22Edit%20Links%20to%20Files%22%3A%20create%20relative%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1854670%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20template%20folder%20containg%20two%20files%20that%20are%20linked%20together%3A%3C%2FP%3E%3CUL%3E%3CLI%3EReport%20template.docx%20(containing%20a%20set%20of%20graphs)%3C%2FLI%3E%3CLI%3EReport%20data.xlsx%20(placeholder%20file%20for%20all%20the%20graph%20data)%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20copy%20this%20folder%2C%20the%20newly%20created%20Word%20document%20will%20keep%20its%20links%20to%20the%20original%20Excel%20file.%20Is%20there%20any%20way%20I%20can%20prevent%20this%20by%20creating%20a%20relative%20link%20to%20%22Report%20data.xlsx%22%20%3CEM%3Ein%20the%20current%20folder%3C%2FEM%3E%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20for%20reference%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.avantixlearning.ca%2Fmicrosoft-word%2Fhow-to-break-update-or-change-links-to-excel-charts-or-worksheets-in-microsoft-word%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Emore%20info%20about%20%22Edit%20Links%20to%20Files%22%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1854670%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1854818%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Word%3A%20%22Edit%20Links%20to%20Files%22%3A%20create%20relative%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1854818%22%20slang%3D%22en-US%22%3E%3CP%3EFound%20the%20answer%20after%20som%20further%20research.%20For%20graphs%20copied%20from%20Excel%20to%20Word%20(Links%20to%20Files)%2C%20relative%20linking%20can%20be%20achieved%20by%20VBA%20macro.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20anyone%20else%20wondering%2C%20see%20the%20bottom%20of%20this%20thread%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.msofficeforums.com%2Fword%2F38722-word-fields-relative-paths-external-files.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.msofficeforums.com%2Fword%2F38722-word-fields-relative-paths-external-files.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

 

I have a template folder containg two files that are linked together:

  • Report template.docx (containing a set of graphs)
  • Report data.xlsx (placeholder file for all the graph data)

 

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"

1 Reply
best response confirmed by Tormod Solem Slupphaug (Contributor)
Solution

Found 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