I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is that when I Copy-Paste them through these Word documents are still linked to the Excel sheet located on the server. That Excel sheet on the server is used by everyone and its content is not meant to be edited. So my question is: Once I have copied the entire folder over to my hard drive with all the documents + Excel sheet, can I somehow force the Word documents to be automatically re-linked to the new Excel mastersheet that I have copied onto my computer (I know how to do this manually but it takes too long as I have a huge amount of Word docs).
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!