Strange problem with hyperlinks!

[Susie]

Some time well over a year ago, through some weird accident that no
one has ever been able to explain, hyperlinks scattered themselves
across a very large spreadsheet. There are two columns of email
addresses that are supposed to be hyperlinks, but now data in several
other cells seems to be linked to these email addresses. It appears
that each cell randomly got an address to link to. I don't know how
or why this happened, but now it is my duty to fix the thing. Rather
than going over more than 6000 rows to see which cells have links and
which ones don't and individually removing the links from the ones
that do, is there a way to maybe select an area or column and just
have it remove whatever links might be in that area?

Thanks in advance for the help!

~S

 

[Geoff Lilley]

Some time well over a year ago, through some weird accident that no
one has ever been able to explain, hyperlinks scattered themselves
across a very large spreadsheet. There are two columns of email
addresses that are supposed to be hyperlinks, but now data in several
other cells seems to be linked to these email addresses. It appears
that each cell randomly got an address to link to. I don't know how
or why this happened, but now it is my duty to fix the thing. Rather
than going over more than 6000 rows to see which cells have links and
which ones don't and individually removing the links from the ones
that do, is there a way to maybe select an area or column and just
have it remove whatever links might be in that area?

Thanks in advance for the help!

~S

I'd recommend using this macro:
Sub ZapHyperlinks()
For x = 1 To ActiveWorkbook.Sheets.Count
Sheets(x).Select
Cells.Hyperlinks.Delete
Next
End Sub

 

[JE McGimpsey]

Some time well over a year ago, through some weird accident that no
one has ever been able to explain, hyperlinks scattered themselves
across a very large spreadsheet. There are two columns of email
addresses that are supposed to be hyperlinks, but now data in several
other cells seems to be linked to these email addresses. It appears
that each cell randomly got an address to link to. I don't know how
or why this happened, but now it is my duty to fix the thing. Rather
than going over more than 6000 rows to see which cells have links and
which ones don't and individually removing the links from the ones
that do, is there a way to maybe select an area or column and just
have it remove whatever links might be in that area?

See

http://www.mcgimpsey.com/excel/nohyperlinks.html