Drag and Drop jumbles Hyperlinks

%3CLINGO-SUB%20id%3D%22lingo-sub-2022257%22%20slang%3D%22en-US%22%3EDrag%20and%20Drop%20jumbles%20Hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022257%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20many%20hyperlinks%20per%20page.%20Some%20are%20to%20other%20cells%20in%20the%20same%20page%20or%20workbook%2C%20some%20to%20other%20files%20in%20subdirectories%20of%20directory%20containing%20workbook%20and%20some%20are%20URLs.%20If%20I%20drag%20and%20drop%20a%20block%20of%20cells%20a%20few%20columns%20to%20the%20right%20to%20a%20destination%20overlapping%20the%20original%20block%20the%20hyperlinks%20jumble.%20Sometimes%20they%20disappear%2C%20sometimes%20they%20pick%20up%20hyperlinks%20from%20different%20cells.%20Often%20there%20are%20no%20problems%20even%20doing%20the%20same%20operation%20(Close%20without%20saving%2C%20reload%20original%20and%20try%20again).%20Hyperlink%20cell%20appearances%20move%20correctly%2C%20so%20there%20is%20no%20way%20of%20knowing%20when%20this%20occurs.%20It%20has%20been%20happening%20for%20years%2C%20but%20I%20only%20recently%20discovered%20cause.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2022257%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025375%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20and%20Drop%20jumbles%20Hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025375%22%20slang%3D%22en-US%22%3E%3CP%3EI%20forgot%20to%20explain%20the%20attachments.%20Hypertest%20is%20the%20%22Before%22%20sheet.%20This%20is%20extracted%20from%20a%20multisheet%20workbook.%20It%20has%20personal%20information%2C%20but%20on%20this%20sheet%20everyone%20has%20been%20dead%20for%20at%20least%20a%20century.%20Hypertest2%20is%20the%20%22After%22%20sheet.%20Cells%20G459-Q482%20have%20been%20Ctrl%2FDragged%20and%20Dropped%202%20columns%20to%20the%20right.%20In%20this%20example%2C%20all%20the%20Hyperlinks%20that%20have%20been%20dragged%20have%20been%20cleared.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a workbook with many hyperlinks per page. Some are to other cells in the same page or workbook, some to other files in subdirectories of directory containing workbook and some are URLs. If I drag and drop a block of cells a few columns to the right to a destination overlapping the original block the hyperlinks jumble. Sometimes they disappear, sometimes they pick up hyperlinks from different cells. Often there are no problems even doing the same operation (Close without saving, reload original and try again). Hyperlink cell appearances move correctly, so there is no way of knowing when this occurs. It has been happening for years, but I only recently discovered cause.

1 Reply

I forgot to explain the attachments. Hypertest is the "Before" sheet. This is extracted from a multisheet workbook. It has personal information, but on this sheet everyone has been dead for at least a century. Hypertest2 is the "After" sheet. Cells G459-Q482 have been Ctrl/Dragged and Dropped 2 columns to the right. In this example, all the Hyperlinks that have been dragged have been cleared.