I have made a spreadsheet for tracking various elements of large meetings, and it contains several links to Word documents which use the Excel data as a mail merge source. But whenever staff moves a copy of the meeting folder containing these documents to their own folders, the spreadsheet persists in linking to the old documents, in the previous location.
I would like to make relative links to these documents in the spreadsheet, so that every time they're moved, the links would not have to be edited.
Much thanks for any help!
Hope