Excel broken link issue in SharePoint Online.

[Wee Teck Tan]

Dear All,

Do you have any experience to fix the broken links from multiple sources (Excel Spreadsheet) once move to SharePoint from Shared File Servers?

They are using the excel formula to link to other source cell as they are from Finance or procurement.

SharePoint Online mentioned that there is disabled and not supported.

How could we resolve this matter?

Please advice.

Thanks.

[#2]

Unfortunately Microsoft does not provide a way to solve this requirement so it's on your side to fix the links in your Excel file. I could think here in thre possible solutions:
1) Explore if you can find a third party product that can do this links fixing for you (No idea if such a product exist)
2) Manually fix the links once the Excel files are migrated in SPO what It's simply too much consuming so not really a solution
3) Using Excel APIs, ask a developer to make a tool to fix the links