hello and sorry for my English,
i have start to migrate to SharePoint O365.
I have somes users with excels files, in this excel files there is hyperlink to other excel file or cells of excel files.
Of course when i migrate documents to SharePoint, the links in excel are broken. So users have to recreate link into excel.
My users use OneDrive to synchronize librairies, so they have the excels files directly OneDrive".
BUT, if they open excel file from OneDrive, they create new link to other excel file (trough OneDrive), the link will be like : c:\user profile\OneDrive\folder\file.xlsx. So it is not good because it create a local link and it should be http://tenant/sites/folder/file.xlsx. If another user click on hyperlink, it will try to connect to c:\user profile (of the user who set the link).
i don't find the solution, how users can recreate link in OneDrive ?
thanks a lot
