Tool to auto fix broken excel links after migration to SharePoint online

We have the same problem, where we have hardcoded links that point to a folder path on a mapped drive letter (L:) in NTFS. It seems like we should be able to "fake out" Excel by migrating the files from the L: drive to SharePoint and then assigning the same exact drive letter mapping for the identical folder path that's now in SharePoint, but Excel is somehow not fooled. Excel complains the linked files can't be found, and then we have to have the user manually update the links anyway -- which is exactly the scenario we were trying to avoid. There are thousands of linked files.

Oliver, we tried your ReplaceMagic tool, but it required that we manually verify the links after they were replaced on a link-by-link basis. That is very tedious when you're talking about thousands of files.

Drive letter mapping in SharePoint Online is much too hard to do, but we have figured out how to do that, thanks to another post we found online (I can share that here if anyone is interested).