Update of Word/Excel links on server

Miro Dimi 1 Reputation point
2022-01-25T09:18:31.393+00:00

Hello Community,

First, sorr for my english. I hope you will understand. :)

In my work, I often use the links between a Word file and an Excel file. In fact, each of our computer files has an Excel sheet as well as a Word document. Each of the Excel tables is pasted into Word with the "paste special" option, allowing a link to be created so that the tables update automatically when changes are made.

Today, when we copy/paste an Excel table into a Word document, the link works but not the updates; that is, in the Word document when we double click on an Excel table, the Excel file opens at the table location. On the other hand, when we make a change in the Excel document and we want to update it in Word, the update does not happen.

The weird thing is that when I do exactly the same thing but with documents on my desktop, the links work. As soon as I move these documents to servers, it doesn't work anymore. Do you know why this happens? Do you need more information? But above all, what can I do to make the update work?

For your information, here is the copy/paste procedure:

In Excel:
Select the table, then Copy

In Word:
Paste the table with the "paste special" option:
168249-image.png

To update the table in Word, right click on the table then :
168189-image.png

Thanks in advance

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
891 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Emily Hua-MSFT 27,526 Reputation points
    2022-01-26T03:26:07.08+00:00

    Hi @Miro Dimi

    Welcome to Q&A forum ~

    > To update the table in Word, right click on the table then :

       According to this description, please right click the table > Linked Worksheet Object > Links, check whether the "Automacti Update" option is selected.  
       ![168552-capture37.jpg][1]  
    
       I also suggest you add the file location on the server as **[a Trusted Location][2]** on Word using a UNC path of the form: `\\server_name\folder_name`.  
    
       Any updates, you can let me know.  
    
       ********************************************  
       If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   
       Note: Please follow the steps in [our documentation][1] to enable e-mail notifications if you want to receive the related email notification for this thread.  
    
       *********************************************  
    
       [1]: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html  
    
       [1]: /api/attachments/168552-capture37.jpg?platform=QnA  
    
       [2]: https://support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4#:~:text=Add%20a%20trusted%20location
    

  2. Miro Dimi 1 Reputation point
    2022-02-03T15:17:01.67+00:00

    Hi, sorry for my late answer. I tried yesterday and it's not the answer that i am looking for as it dosen't work...
    It is very strange, because we are 8 people working on the same documents and it only work for one person. The other one we have the same problem.


  3. Kim 0 Reputation points
    2023-02-21T09:54:25.1333333+00:00

    I got the same problem that links won't get updated if excel file is saved on server. Hope there is solution

    0 comments No comments