Hyper links in excel broken with office 365 update

%3CLINGO-SUB%20id%3D%22lingo-sub-2292044%22%20slang%3D%22en-US%22%3EHyper%20links%20in%20excel%20broken%20with%20office%20365%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292044%22%20slang%3D%22en-US%22%3E%3CP%3EOk..%20I%20maintain%20a%20database%20with%20links%20to%20quote%20files%2C%20correspondence%2C%20data%20sheets%2C%20and%20part%20numbers%20in%20a%20master%20file%20using%20excel.%20The%20file%20currently%20has%20over%205000%20hyperlinks.%26nbsp%3B%20This%20morning%20my%20computer%20told%20me%20that%20office%20365%20had%20updates%20and%20being%20a%20slow%20monday%20I%20chose%20to%20allow%20the%20update%2C%20followed%20by%20restarting%20the%20computer.%20So%20now%20EVERY%20link%20has%20an%20additional%20portion%20added%20pointing%20to%20temporary%20files%20and%20NO%20links%20work.%20I%20can%20edit%20each%20link%2C%20I%20can%20remove%20the%20same%20items%20from%20each%20link..%20but%20doing%20this%20one%20at%20a%20time%20for%20over%205000%20has%20created%20a%20lot%20of%20work...%20thanks%20for%20the%20update%20Microsoft!%20..%20so%20..%20there%20must%20be%20an%20easy%20way%20to%20unscrew%20this%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2292044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2292521%22%20slang%3D%22en-US%22%3ERe%3A%20Hyper%20links%20in%20excel%20broken%20with%20office%20365%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292521%22%20slang%3D%22en-US%22%3EIf%20this%20is%20a%20problem%20which%20you%20could%20fix%20with%20search%20and%20replace%2C%20try%20my%20free%20Flexfind%20add-in.%20Check%20the%20%22Objects%22%20box%20to%20have%20it%20search%20hyperlinks.%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2Fofficemarketplaceff-en.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2Fofficemarketplaceff-en.asp%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

Ok.. I maintain a database with links to quote files, correspondence, data sheets, and part numbers in a master file using excel. The file currently has over 5000 hyperlinks.  This morning my computer told me that office 365 had updates and being a slow monday I chose to allow the update, followed by restarting the computer. So now EVERY link has an additional portion added pointing to temporary files and NO links work. I can edit each link, I can remove the same items from each link.. but doing this one at a time for over 5000 has created a lot of work... thanks for the update Microsoft! .. so .. there must be an easy way to unscrew this up.

2 Replies
If this is a problem which you could fix with search and replace, try my free Flexfind add-in. Check the "Objects" box to have it search hyperlinks. https://jkp-ads.com/officemarketplaceff-en.asp

@Jan Karel Pieterse   Thanks however, I restored an older version of the file from back up.. then had to re enter the 3 new items.  Still... This should not have happened from an update.