After saving and re-opening the file, the link has disappeared (this object has become corrupt and is no longer available).    If I try to update the link via the "Prepare" function, I get the message "

The problem is because the linked file is on a file server on the network.   If I try to connect to to a file locally, it works.  So something is wrong with the OLE access between the word document and the file server.

   In the Trust center, I enabled external data connections and made it possible to trust documents from external locations.   In addition, I added the IP address of the file server to the trusted locations (by means of http://www.doztech.net/microsoftoffice/add-trusted-locations-in-office-2010/).  

Nothing works.   Can anyone help me out?  I spent half a day on it already...   BTW : I don't have Norton antivirus on my PC and I run Windows 7

Hi,

You may use link the Excel worksheet if you want to update whenever the source file is updated.

If you embed the worksheet in the report, your report contains a static copy of the data.

1. In Word 2010, click Insert tab, on the Text group.
2. Drop-down Object > Object...
3. Click Create from File tab, click Browse and select Excel file you want.
4. Select Link to file check box, and click OK.
   
   

LINKED OBJECTS
When an object is linked, information can be updated if the source file is modified. Linked data is stored in the source file. The Word file, or destination file, stores only the location of the source file, and it displays a representation of the linked data. Use linked objects if file size is a consideration.

Linking is also useful when you want to include information that is maintained independently, such as data collected by a different department, and when you need to keep that information up-to-date in a Word document.

EMBEDDED OBJECTS
When you embed an Excel object, information in the Word file doesn't change if you modify the source Excel file. Embedded objects become part of the Word file and, after they are inserted, they are no longer part of the source file.

Because the information is totally contained in one Word document, embedding is useful when you don't want the information to reflect changes in the source file, or when you don't want the document recipients to be concerned with updating the linked information.

Best regards.

Hi,

did you find the solution?

Brgds,

Marcelo