Migration of File Share to SharePoint Online with Macro and linked excel files

Darwin Goh 1 Reputation point
2022-04-25T02:00:57.61+00:00

Hi, I'm planning a migration of file servers to Sharepoint online. However the challenges have now been that in the file server, there are many old excel files that are linked and some of them are even macro enabled. I would like to check how the latest SharePoint online deal with such files and is there any migration tool that is possible to migrated such files without breaking them.

Microsoft 365 and Office SharePoint For business Windows
{count} votes

1 answer

Sort by: Most helpful
  1. CaseyYang-MSFT 10,461 Reputation points
    2022-04-25T07:04:01.26+00:00

    Hi @Darwin Goh ,

    There is no available migration tool to migrate linked excel files without breaking links. You could use SharePoint Migration Tool to migrate files from file share to SharePoint online then use some other third-party tools to fix broken excel links.

    For Reference:
    Tool to auto fix broken excel links after migration to SharePoint online
    Migrate Excel files with a lot of links to SharePoint Online?


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.