Error with hyperlinks in Excel files moved to OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-1412643%22%20slang%3D%22en-US%22%3EError%20with%20hyperlinks%20in%20Excel%20files%20moved%20to%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1412643%22%20slang%3D%22en-US%22%3E%3CDIV%3EHi%20Community%2C%3C%2FDIV%3E%3CDIV%3EListen%2C%20I%20have%20a%20question%3A%3C%2FDIV%3E%3CDIV%3EWe%20have%20been%20working%20on%20enabling%20OneDrive%20for%20all%20our%20users%20worldwide%20and%20also%20users%20are%20synchronizing%20their%20%5CDocuments%5C%20folder%26nbsp%3B%20with%20OneDrive%3C%2FDIV%3E%3CDIV%3ESome%20of%20the%20users%20already%20had%20large%20Excel%20files%20with%20Hyperlinks%20between%20a%20source%20Excel%20file%20and%20a%20target%20Excel%20file.%20Sometime%20multiple%20Sources%20files.%3C%2FDIV%3E%3CDIV%3EThe%20situation%20we%20are%20seeing%20is%20that%20now%20that%20the%20files%20are%20in%20OneDrive%20their%20hyperlinks%20are%20no%20longer%20working%20or%20updating%20to%20the%20new%20routes.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThey%20have%20tried%20to%20update%20the%20links%20inside%20the%20files%2C%20but%20they%20get%20some%20errors%2C%20one%20of%20them%20for%20example%20is%3A%20%22The%20linked%20file%20was%20unavailable%20and%20can't%20be%20updated%22%3C%2FDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Kenneth905_0-1590180019983.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193998i5EC6E8FD8A9B1FF9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Kenneth905_0-1590180019983.png%22%20alt%3D%22Kenneth905_0-1590180019983.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3EIs%20OneDrive%20designed%20to%20handle%20Excel%20files%20with%20hyperlinks%3F%20Or%20is%20there%20any%20special%20configuration%20that%20must%20be%20made%20in%20OneDrive%20or%20in%20the%20files%20themselves%3F%3C%2FDIV%3E%3CDIV%3EPlease%20advise!%3C%2FDIV%3E%3CDIV%3EThanks%20a%20lot.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1412643%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi Community,
Listen, I have a question:
We have been working on enabling OneDrive for all our users worldwide and also users are synchronizing their \Documents\ folder  with OneDrive
Some of the users already had large Excel files with Hyperlinks between a source Excel file and a target Excel file. Sometime multiple Sources files.
The situation we are seeing is that now that the files are in OneDrive their hyperlinks are no longer working or updating to the new routes.
 
They have tried to update the links inside the files, but they get some errors, one of them for example is: "The linked file was unavailable and can't be updated"
Kenneth905_0-1590180019983.png
Is OneDrive designed to handle Excel files with hyperlinks? Or is there any special configuration that must be made in OneDrive or in the files themselves?
Please advise!
Thanks a lot.
1 Reply
We get the same error message when a user tries to update a OLE linked Excel in PowerPoint. The cause is that the creator of the files has Office in French and the person that tries to update the link has Office in English. We confirmed it by changing the language.