I have small list of hourly rates in excel that I want to link to a word 2013 document. First it will not show me changes in real-time and I tried following various manuals on youtube but after I close the word document somehow the links break and not even updating manually works. Normally I work with files on OneDrive and I thought it was maybe a OneDrive problem but the problem was same with local files. Any help or suggestion would be appreciated.

This is my word doc.



This is my excel doc.

AFAIK you cannot link to files via a http address, which is what your document is trying to do. If you make local copies of the files, you then have to change the link paths to point to wherever the local files are - simply copying them to the same folder isn't enough. Once you do that, the links should work (they do on my system).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Files location are on my onedrive cloud storage and I even tried to copy them on my local disk c: and create a new document that is linked to the excel document om my local disk but still no luck.

Perhaps there's a fault in your Office installation. Have you tried repairing it (via Programs & Features > Microsoft Office > Change in the Windows Control Panel)?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I tried repairing office installation after you suggestion and partly it solved the problem. The local files on my c: drive are working and updating in real time however the files on onedrive are still not working and every time i close my word document the link is broken next time I open the document.

That is consistent with what I posted before about links to URLs:

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I found that hard to believe then what is the point working with office365 if I can't even link tables...I think I may need a second opinion and I will cross post on other forums. Thank you for your answers and I will update this thread if there is a solution.