Good morning,

Setting up this post as I was unable to identify any solutions online;

I am currently trying to set-up and link a set of tables from excel to the word (printable) version. Up till now the process has been manual (where we copy the tables from excel and paste on word). We have started linking these tables from the excel to the word version, so that we avoid the manual inputting of the tables into word everytime there is an update. This is done by a normal ctrl c, and pasting RTF (linked) on word. The link works and one is able to update the different tables real time (as soon there is an update on excel, it updates automatically on word, when both are open). This works until we save and close the word document. Once the document is closed, and re-opened, word promts us that the link is lost and/or possibly corrupted.

Through some testing and online searching, we have identified that there is a difference between working on the local physical drive of the laptop and the network. The links remain active and working when working with both files locally, however, this is lost when the same work is performed on an online shared drive (this occurs on both Onedrive as well as the company network). It was noted that these links can be "recovered" by manually pressing F9 on the table. This is however a temporary fix as the links remains active only until the word document is closed again (and one would still need to manually push the update of a table for the changes to take place).

Is there any way we can achieve and keep the link when working on the drive, since this is usually utilised by a number of people at a time?

Thanks in advance!

Kind regards,

Jonathan