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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
W10-1903 UNC path failing 0x80070043
kurgan in Windows Insider Program on
80 Replies