Jim,
Yes, Edit Clear All does get rid of ALL hyperlinks and text in the cell,
but that doesn't explain why I'm having a problem with the hyperlinks to
begin with. Let me try to explain further: I add a hyperlink to a cell
that has text in it. The link works correctly when I click on it. I close
out of Excel. Some time later when I go back in the workbook, that link may
not be going to the same URL I just put in it. Also, some of the cells with
incorrect links now seem to have several different links within that one
cell. (e.g. using the 'insert hyperlink' and 'remove link' option INSTEAD OF
Edit Clear All I find two or more different links in the cell.) We
regularly have to add and delete rows. Would this effect the hyperlinks?
Also, I'm wondering if someone 'sorted' on one of the columns via Data
Sort, saved the file, and then later tried to return it to it's original
state. Would this effect the hyperlinks?

I might be able to send you a scaled down version of this spreadsheet, but
you will not be able to access any of the links.


"Jim Rech" wrote:

I'm not sure I'm following you completely but if you do an Edit, Clear, All
don't you then wind up with an empty cell into which you then insert the a
new hyperlink?

--
Jim Rech
Excel MVP
"Lynde" wrote in message
...
|I hope I can explain this well enough for everyone to understand. Here
goes:
| I am using Excel 2003. I have a workbook that has approx. 2,300 Rows of
| data. Within each row there are 4 Columns that contain different
hyperlinks
| that go to corporate websites. I have come across some errors where the
| hyperlinks are going to the wrong URL. Sometimes when I click the 'Insert
| Hyperlink' button and 'Remove Hyperlink', I find that when I go to relink
the
| cell, it still has another hyperlink even though I just removed one. It's
| like there were two different hyperlinks in one cell. How does this
happen?
| And is there a way to fix it or prevent it from happening again? Also
note,
| that many people use this workbook. Once a month it gets filtered (using
the
| AutoFilter feature and Custom AutoFilter) and unneeded cells are deleted.
| Would doing this repeatedly on the same workbook effect the hyperlinks?
| Please let me know if this is not clear. I am unable to send the workbook
to
| anyone due to corporate policies and confidential information.
|
| Thank you for any help you can give.