Nov 25 2018 11:50 AM
Nov 25 2018 11:50 AM
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.
Nov 27 2018 11:29 AM
Dec 29 2018 04:55 AM
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
Jun 03 2021 09:58 AM
Jun 17 2021 11:32 AM
Jun 17 2021 01:34 PM
Jun 17 2021 01:36 PM
Jun 17 2021 01:38 PM
Jun 18 2021 03:05 AM
Jun 18 2021 02:18 PM
Set the base address for the links in a workbook
By default, unspecified paths to hyperlink destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time that you create a link to a file in that location, you only have to specify the file name, not the path, in the Insert Hyperlink dialog box.
Follow one of the steps depending on the Excel version you are using:
Note: You can override the link base address by using the full, or absolute, address for the link in the Insert Hyperlink dialog box.
Jun 18 2021 02:24 PM
Sep 15 2022 09:04 PM
Is that modern tools to perform migration for linked Excels? We have many linked Excel and would like to migrate to SharePoint Online. Thanks a lot.
Sep 15 2022 09:11 PM
Sep 15 2022 11:46 PM
@JamesT100ReplaceMagic can help with fixing links after migration to SharePoint.
In general, you have relative or absolute links and, if we assume, that absolute links is:
and that in the future, on SharePoint, it will be:
you can just set that ReplaceMagic searches for \\ServerABC and replaces it with http://company.sharepoint.com/sites/site/DocLib. Of course, tool can align slashes or backslashes.
Final result will be https://company.sharepoint.com/sites/site/DocLib/Folder/SubFolder/filename and of course, all link where we have match with your search string will be updated.
Similar applies for relative links. For example, you have something like:
you can replace it by searching for \Folder and making replacement with https://company.sharepoint.com/sites/site/DocLib/Folder
With this approach all files in selected location will get this change.
To get initial idea about your links you can do scan of files after migration (of course, you can do that also before migration) and ReplaceMagic will create snapshot of everything found (btw. you do not need to buy the tool to do scanning) which will be starting point to see what kind of links you will need to fix.