Home

Edit Links -> Change Source not saving changes to linked file location

%3CLINGO-SUB%20id%3D%22lingo-sub-290089%22%20slang%3D%22en-US%22%3EEdit%20Links%20-%26gt%3B%20Change%20Source%20not%20saving%20changes%20to%20linked%20file%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290089%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20move%20a%20set%20of%20Excel%20files%20that%20have%20linked%20source%20files.%26nbsp%3B%20When%20I%20move%20them%20and%20then%20choose%20Edit%20Links%20and%20Change%20Source%20to%20point%20to%20the%20linked%20file%20in%20its%20new%20location%2C%20it%20appears%20to%20work%20at%20first.%26nbsp%3B%20The%20Open%20Source%20and%20Check%20Status%20buttons%20appear%20to%20be%20pointing%20to%20the%20new%20location%2C%20but%20the%20location%20showing%20just%20below%20the%20file%20list%20is%20still%20the%20previous%20location.%26nbsp%3B%20When%20I%20save%2C%20close%20and%20reopen%20the%20file%2C%20my%20changes%20did%20not%20take.%26nbsp%3B%20It%20sill%20points%20to%20the%20previous%20location.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-290089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561553%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20Links%20-%26gt%3B%20Change%20Source%20not%20saving%20changes%20to%20linked%20file%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F244916%22%20target%3D%22_blank%22%3E%40r_hof%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem.%20Any%20solutions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561560%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20Links%20-%26gt%3B%20Change%20Source%20not%20saving%20changes%20to%20linked%20file%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561560%22%20slang%3D%22en-US%22%3ENo.%20We%20eventually%20gave%20up%20and%20the%20files%20are%20still%20on%20prem.%20We%20may%20give%20it%20another%20try%20during%20another%20iteration%20of%20the%20SharePoint%20migration.%20I%20have%20tested%20with%20files%20made%20from%20scratch%20and%20can%20make%20it%20work%2C%20but%20so%20far%20not%20with%20those%20legacy%20files.%20One%20thought%20I%20later%20had%20but%20haven%E2%80%99t%20tested%20is%20whether%20the%20files%20may%20be%20opening%20as%20a%20previous%20version%20and%20need%20to%20be%20saved%20as%20the%20newest%20version%20to%20get%20this%20to%20work.%20It%20has%20been%20awhile%20since%20we%20moved%20on%20from%20this%20so%20I%E2%80%99m%20not%20sure%20at%20this%20point.%3C%2FLINGO-BODY%3E
r_hof
New Contributor

I need to move a set of Excel files that have linked source files.  When I move them and then choose Edit Links and Change Source to point to the linked file in its new location, it appears to work at first.  The Open Source and Check Status buttons appear to be pointing to the new location, but the location showing just below the file list is still the previous location.  When I save, close and reopen the file, my changes did not take.  It sill points to the previous location.  Any suggestions?

2 Replies

@r_hof 

I have the same problem. Any solutions?

No. We eventually gave up and the files are still on prem. We may give it another try during another iteration of the SharePoint migration. I have tested with files made from scratch and can make it work, but so far not with those legacy files. One thought I later had but haven’t tested is whether the files may be opening as a previous version and need to be saved as the newest version to get this to work. It has been awhile since we moved on from this so I’m not sure at this point.