We are migrating one of our customer's file share the SharePoint online, and we getting big pushback from their finance department, as they have a lot of linked excel files. file link is broken after we test file move. We know we could change the link to URL. However, it is very hard to go through and change all the link and not impact the end users.
Just wondering if anyone has similar experience before to share how you overcome this issue. also if you know any good tool can help to auto-fix the broken links.
I just have a look at the tool, It is great for fix link for migrating to SharePoint on-premise. the document link of SharePoint online is a bit different it contains a hash, it is a bit hard to use this logic to fix the links.
you can try our tool => ReplaceMagic (check: www.replacemagic.com). In recent months almost 70% of migrations that we are supporting are to SharePoint.Online with all possible documents types (yes, changes in Excel will also work).
In case of any questions you can always contact us.