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

%3CLINGO-SUB%20id%3D%22lingo-sub-290940%22%20slang%3D%22en-US%22%3ETool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290940%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20migrating%20one%20of%20our%20customer's%20file%20share%20the%20SharePoint%20online%2C%20and%20we%20getting%20big%20pushback%20from%20their%20finance%20department%2C%20as%20they%20have%20a%20lot%20of%20linked%20excel%20files.%20file%20link%20is%20broken%20after%20we%20test%20file%20move.%26nbsp%3B%20We%20know%20we%20could%20change%20the%20link%20to%20URL.%20However%2C%20it%20is%20very%20hard%20to%20go%20through%26nbsp%3Band%20change%20all%20the%20link%20and%20not%20impact%20the%20end%20users.%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wondering%20if%20anyone%20has%20similar%20experience%20before%20to%20share%20how%20you%20overcome%20this%20issue.%20also%20if%20you%20know%20any%20good%20tool%20can%20help%20to%20auto-fix%20the%20broken%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-290940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307428%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307428%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3BLei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20try%20our%20tool%20%3D%26gt%3B%20ReplaceMagic%20(check%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.replacemagic.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ewww.replacemagic.com%3C%2FA%3E).%20In%20recent%20months%20almost%2070%25%20of%20migrations%20that%20we%20are%20supporting%20are%20to%20SharePoint.Online%20with%20all%20possible%20documents%20types%20(yes%2C%20changes%20in%20Excel%20will%20also%20work).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20case%20of%20any%20questions%20you%20can%20always%20contact%20us.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBtw.%20we%20work%20natively%20with%20SharePoint%20(you%20can%20connect%20to%20it%20directly%20from%20ReplaceMagic).%20More%20infos%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.replacemagic.com%2FHowToUseSharePoint.aspx%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.replacemagic.com%2FHowToUseSharePoint.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBR%2C%3C%2FP%3E%3CP%3EOliver%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292077%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292077%22%20slang%3D%22en-US%22%3EWhat%20problems%20do%20the%20hash%20cause%20preciesly%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291836%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291836%22%20slang%3D%22en-US%22%3Ethanks%2C%20Jan%3CBR%20%2F%3E%3CBR%20%2F%3EI%20just%20have%20a%20look%20at%20the%20tool%2C%20It%20is%20great%20for%20fix%20link%20for%20migrating%20to%20SharePoint%20on-premise.%20the%20document%20link%20of%20SharePoint%20online%20is%20a%20bit%20different%20it%20contains%20a%20hash%2C%20it%20is%20a%20bit%20hard%20to%20use%20this%20logic%20to%20fix%20the%20links.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20keep%20looking.%20Thanks%20for%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291054%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291054%22%20slang%3D%22en-US%22%3ESee%3A%20%3CA%20href%3D%22http%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Flinkmgr.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Flinkmgr.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2413384%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413384%22%20slang%3D%22en-US%22%3EWe%20have%20the%20same%20problem%2C%20where%20we%20have%20hardcoded%20links%20that%20point%20to%20a%20folder%20path%20on%20a%20mapped%20drive%20letter%20(L%3A)%20in%20NTFS.%20It%20seems%20like%20we%20should%20be%20able%20to%20%22fake%20out%22%20Excel%20by%20migrating%20the%20files%20from%20the%20L%3A%20drive%20to%20SharePoint%20and%20then%20assigning%20the%20same%20exact%20drive%20letter%20mapping%20for%20the%20identical%20folder%20path%20that's%20now%20in%20SharePoint%2C%20but%20Excel%20is%20somehow%20not%20fooled.%20Excel%20complains%20the%20linked%20files%20can't%20be%20found%2C%20and%20then%20we%20have%20to%20have%20the%20user%20manually%20update%20the%20links%20anyway%20--%20which%20is%20exactly%20the%20scenario%20we%20were%20trying%20to%20avoid.%20There%20are%20thousands%20of%20linked%20files.%3CBR%20%2F%3E%3CBR%20%2F%3EOliver%2C%20we%20tried%20your%20ReplaceMagic%20tool%2C%20but%20it%20required%20that%20we%20manually%20verify%20the%20links%20after%20they%20were%20replaced%20on%20a%20link-by-link%20basis.%20That%20is%20very%20tedious%20when%20you're%20talking%20about%20thousands%20of%20files.%3CBR%20%2F%3E%3CBR%20%2F%3EDrive%20letter%20mapping%20in%20SharePoint%20Online%20is%20much%20too%20hard%20to%20do%2C%20but%20we%20have%20figured%20out%20how%20to%20do%20that%2C%20thanks%20to%20another%20post%20we%20found%20online%20(I%20can%20share%20that%20here%20if%20anyone%20is%20interested).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2459948%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2459948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F962447%22%20target%3D%22_blank%22%3E%40NBS42%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20love%20to%20hear%20how%20you%20worked%20around%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2459970%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2459970%22%20slang%3D%22en-US%22%3EHi%20NBS42%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ewhy%20you%20had%20manually%20to%20check%20links%20as%20if%20you%20go%20to%20Configuration%20%3D%26gt%3B%20Processing%20there%20are%202%20options%20to%20check%20links%3A%3CBR%20%2F%3E1.%20Check%20does%20hyperlink%20exist%3CBR%20%2F%3E2.%20Check%20does%20file%20link%20exist%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20in%20newer%20versions%20of%20software%20we%20included%20under%20Configuration%20%3D%26gt%3B%20SharePoint%20%22Native%20SharePoint%20check%20of%20broken%20links%22%20but%20this%20will%20for%20every%20link%20send%20request%20through%20CSOM%20to%20SharePoint%20which%20will%20increase%20risk%20of%20throttling%20which%20is%20anyway%20due%20to%20Covid%20high.%3CBR%20%2F%3E%3CBR%20%2F%3EOne%20important%20point%20-%20to%20get%20understanding%20of%20your%20links%20scanning%20of%20documents%20and%20check%20if%20links%20are%20broken%20is%20completely%20free.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2460509%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2460509%22%20slang%3D%22en-US%22%3EHi%2C%20Steve.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20I%20spoke%20too%20soon%20that%20we%20have%20a%20solution%20for%20drive%20letter%20mapping.%20I%20think%20these%20are%20the%20instructions%20I%20initially%20found%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.clouddirect.net%2Fknowledge-base%2FKB0011543%2Fmapping-a-sharepoint-site-as-a-network-drive%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.clouddirect.net%2Fknowledge-base%2FKB0011543%2Fmapping-a-sharepoint-site-as-a-network-drive%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20requires%20the%20use%20of%20Internet%20Explorer%2C%20which%20we%20know%20to%20be%20obsolete%20software.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20are%20working%20on%20an%20alternative%20approach%20where%20we%20hope%20to%20push%20out%20drive%20letter%20mapping%20via%20GPO%2C%20but%20that's%20not%20fully%20baked%20yet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2460515%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2460515%22%20slang%3D%22en-US%22%3EHmm.%20A%20colleague%20was%20using%20the%20tool%20firsthand.%20I%20didn't%20try%20it%20myself.%20Maybe%20we%20need%20to%20look%20at%20again.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2460520%22%20slang%3D%22en-US%22%3ERe%3A%20Tool%20to%20auto%20fix%20broken%20excel%20links%20after%20migration%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2460520%22%20slang%3D%22en-US%22%3EIf%20you%20want%20we%20can%20always%20setup%20Teams%20and%20do%20brainstorming%20together%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20You%20can%20always%20reach%20us%20over%20support(%40).replacemagic.com%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

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.

 

Thanks :)

11 Replies
thanks, Jan

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.

I will keep looking. Thanks for your help :)
What problems do the hash cause preciesly?

Hi Lei,

 

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.

 

Btw. we work natively with SharePoint (you can connect to it directly from ReplaceMagic). More infos: https://www.replacemagic.com/HowToUseSharePoint.aspx

 

BR,

Oliver

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).

@NBS42 

I'd love to hear how you worked around this.

 

Hi NBS42,

why you had manually to check links as if you go to Configuration => Processing there are 2 options to check links:
1. Check does hyperlink exist
2. Check does file link exist

Also in newer versions of software we included under Configuration => SharePoint "Native SharePoint check of broken links" but this will for every link send request through CSOM to SharePoint which will increase risk of throttling which is anyway due to Covid high.

One important point - to get understanding of your links scanning of documents and check if links are broken is completely free.
Hi, Steve.

I think I spoke too soon that we have a solution for drive letter mapping. I think these are the instructions I initially found:
https://www.clouddirect.net/knowledge-base/KB0011543/mapping-a-sharepoint-site-as-a-network-drive

It requires the use of Internet Explorer, which we know to be obsolete software.

We are working on an alternative approach where we hope to push out drive letter mapping via GPO, but that's not fully baked yet.
Hmm. A colleague was using the tool firsthand. I didn't try it myself. Maybe we need to look at again.
If you want we can always setup Teams and do brainstorming together You can always reach us over support(@).replacemagic.com
No need for Internet Explorer. You can go to Classic view of the document library in question (there's a link on the botton-left of the window in my library to do that). After that, you can open the library you want to use as a drive, click on the Library tab at the top and click Open with Explorer.