Forum Discussion
Kdiniz
Jun 08, 2019Copper Contributor
Excel link does not work in a word document saved at onedrive
Hello, I have a word document with some links to excel workbooks. The update process between excel and word was working properly until I started do save these files in One-Drive. I've checked the ...
Ty_Griffin
Sep 10, 2021Copper Contributor
I can confirm that the problem you're describing is REAL and that you are not doing anything wrong. None of the suggestions/solutions offered by other people here are any good; I've tried them all and they make no difference. Although linking from Excel to Word documents has worked well in the past, Microsoft seems to have completely broken the process with OneDrive. When you paste the link (from the Excel segment) into Word, it stores the link NOT as a regular file link but instead as a OneDrive URL. If you save the Word file and re-open, Word gives an error that the link cannot be updated. I've struggled with this for several days and tried everything I can think of, nothing helps. It appears to be a bonafide bug in the new (post OneDrive) implemention of linking. If you move the Excel file to a non-OneDrive location, the linking works properly and as it always has.
- KdinizSep 19, 2021Copper ContributorThat's true Ty_Griffin.
I think the problem is related the was the office apps save the location path of the embedded files when using OneDrive. Any way, unfortunately, I've given up using OneDrive when I need to use embedded files...