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).
February 17, 2010 11:37 PM
February 18, 2010 2:42 PM