Migrating linked Excel files to SPO

%3CLINGO-SUB%20id%3D%22lingo-sub-3493413%22%20slang%3D%22en-US%22%3EMigrating%20linked%20Excel%20files%20to%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3493413%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%20Everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20migrate%20a%20document%20library%20containing%20hundreds%20of%20excel%20files%20from%20SharePoint%202013%20to%20SPO%20using%20SPMT%20(Share%20Point%20Migration%20Tool).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20most%20of%20these%20Excel%20files%20contain%20cells%20that%20are%20linked%20to%20other%20Excel%20files%20on%20SP2013%20and%20SPMT%20does%20not%20take%20that%20into%20consideration.%20So%20the%20links%20aren't%20updated%20during%20migration.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20solution%20to%20this%20problem%3F%20(without%20using%20a%20third%20party%20software%20or%20tool)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3493413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3494992%22%20slang%3D%22en-US%22%3ERe%3A%20Migrating%20linked%20Excel%20files%20to%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3494992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1420405%22%20target%3D%22_blank%22%3E%40BacharHajjar%3C%2FA%3E%26nbsp%3BI'm%20afraid%20you%20have%20to%20update%20manually%20or%20through%20PowerShell%20script%20the%20cells%20after%20the%20migration%20to%20SPO.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESPMT%20or%20whatever%203rd%20party%20tool%20used%20for%20SharePoint%20migration%20is%20not%20analyzing%20the%20content%20%3CEM%3E(cells%20in%20Excel%20in%20your%20case)%3C%2FEM%3E%2C%20they%20only%20keep%2Fdetect%20permissions%2C%20metadata%20and%20properties%20linked%20to%20the%20specific%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good Day Everyone, 

 

I'm trying to migrate a document library containing hundreds of excel files from SharePoint 2013 to SPO using SPMT (Share Point Migration Tool).

 

The problem is that most of these Excel files contain cells that are linked to other Excel files on SP2013 and SPMT does not take that into consideration. So the links aren't updated during migration.

 

Does anyone have a solution to this problem? (without using a third party software or tool)

 

Thanks in advance !

 

 

1 Reply

@BacharHajjar I'm afraid you have to update manually or through PowerShell script the cells after the migration to SPO.

 

SPMT or whatever 3rd party tool used for SharePoint migration is not analyzing the content (cells in Excel in your case), they only keep/detect permissions, metadata and properties linked to the specific file