Linking Excel Workbook to Fill Out Report in Word

You could add the 'Edit Links' button to Word's QAT, which will facilitate updating the links to point to the new workbook/location. Even without that the links can be updated by choosing File>Edit Links (look in the lower-right corner of the screen). If you're moving both the document and the workbook, but the path between them remains the same, see the macro solution I've posted at: http://windowssecrets.com/forums/sho...External-Files

Originally Posted by JNEWBURY2280

I tried using your VB code but say if I cut the Word and Excel together and paste them into a new folder each time it tries to update the links they are broken.

A simple way of updating the links manually is to open the document, press Alt-F9 to expose the field code, then use Find/Replace to change whatever part needs changing. Indeed, if you go changing the Excel filename, you'll need to do that (or use Edit Links) anyway.

Do I need to run the code or something? This is all new to me. I am Using Word 2013 if that makes any difference. Is it ok to rename the Module to Link_Fix?

As stated in the link:
"simply extract the file from the zip archive, open up the Word VBE (Alt-F11) and import the file into the document you want to use it with, then save the document."
There is no 'running' to be done - the macro runs automatically every time the document containing it is opened. As for renaming the Module, sure, but I can't see the point unless you already have a module of the same name in the document.

Also the updating process is very slow when opening the file. Would you suggest only have one link from the excel to the word and then making an OLE Link if the data repeats in the document? Would that make it faster?

If you reference the same Excel cell(s) in multiple places, it's far more efficient to insert one link to it/them, bookmark it then insert cross-references to that bookmark.

Originally Posted by JNEWBURY2280

So if I move the file or rename it I will have to update with links regardless of have th VBA code in the document?

I though that is what the VBA code was created to fix.

You would really do yourself a favour if you paid attention. The VBA code fixes the links for a changed path, but not for a changed name. The whole premises upon which it works is for simulating relative paths - that's even what the thread title in the link says.

Originally Posted by JNEWBURY2280

If the links are broken it all goes to plain text

Wrong.

Way easier just to do it by hand.

You're still not paying attention. I have already told you a very easy way of doing it via Find/Replace.

It seems like Microsoft would include a Name Manger within word as it does in Excel that would allow you to create names for certain ranges that are linked to a single file.

But Word isn't Excel and doesn't even use defined names...