Trying to make a master document in Word to link to several Excel files.

**gotbitey** · 03-06-2012, 12:33 PM

Trying to make a master document in Word to link to several Excel files. When i edit the word document i want it to update automaticly in the excel file.

**mahju** · 03-06-2012, 02:08 PM

Hi
Copy the required part in word and pasteapecial + Paste link in excel file

A link will be created and that will be updated automaticaly

Save the word file first and after each change in word file to reflect the change in excel

Regards

**gotbitey** · 03-06-2012, 02:16 PM

Thank you i figured it was something simple that i was missing.

**mahju** · 03-06-2012, 02:39 PM

Glad to help

Please mark the thread as solved

Regards

**gotbitey** · 03-06-2012, 03:18 PM

I might of ran into a problem, it was working great until i saved it and closed it. Then when i reopened and was testing again it was updating, do i have to re paste it every time a change occurs?

**mahju** · 03-07-2012, 06:45 AM

Hi

In office 2003 amd latter when opening a file containing external link or VBA a warning message above worksheet will appear containing an option button. Click the button and select "enable the contents"

Or click open the trust center at bottom to manage VBA or External links

One thing more. First chose a folder etc where you want to have both files. Because after changing the folder / file name problem may occure (I have not used this techicique much).

Hope it helps

Regards

hope this help