Home

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%3A)%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%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%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%3A)%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%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Flinkmgr.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E
Lei Zhou
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 :)

4 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