New
#1
Remove hidden hyperlinks in Excel 2003
Hi,
I have been contaminated with hidden hyperlinks in an Excel 2003 workbook, and I can't get rid of them.
I copy-pasted a table of data from a website, however there were some columns with links in there, and they got pasted with the data. What happens is I have blank cells, and over some of them, the cursor changes the way it should over a hyperlink, and a pop-up appears. When I click into the cell to type something, the link opens in my browser instead.
I also have something else happening in those cells. Sometimes there's a little shape appearing, the sort which seems related to drawing or images (sorry, I can't be specific here, I don't know the name of that object nor what it is, and it's a foreign version of Office).
I've tried the following :
- Deleting the columns.
- Right-clicking over each cell and deleting the invisible hyperlink.
- Creating a new sheet and copying only the adjacent data, without the contaminated columns.
- Running this macro.
Nothing works. I tried to create my own hyperlinks in those contaminated cells and they work (links to local files), however I have also the parasitic, phantom links remaining : when I hover somewhere on the left of the cell, it's that link that is detected and not mine. When I copy-paste those cells someplace else in the sheet, both links get copied : mine, and the phantom one. And both "work". Another experiment : when I delete the column contaminated by the phantom links, they "jump" to the adjacent blank column.
Very weird. Any ideas ?
Last edited by Clairvaux; 26 Nov 2016 at 04:17. Reason: Added info. More experimenting.