Still need help

[BurgrLvr]

I have a spreadsheet that is 3604 rows & 6 columns. Column E has only
hyperlinks to URL's. I have filtered my data via column B. I tried to A-Z
Column A. When I do, the hyperlinks do not stay with the data. The mask
looks correct but when you scroll over the hyperlink you see a completely
different URL.????? Can anyone tell me how to make sure the Hyperlink keeps
the correct URL when filtering and sorting the data.

Try using the =HYPERLINK() worksheet function

Thanks Tim for answering, hoping you're still there. I tried it and it works
with the hyperlinks that are ok, but some of my hyperlinks when you scroll
over them show as-> blocked::http:\\ before the address and those
aren't stayng intact. Any idea why I'm getting that "blocked" inserted into
my hyperlink? How can I get rid of it?

This was from yesterday so I thought it may not get answered as it is too
old so I submitted again.

 

[BurgrLvr]

I have a spreadsheet that is 3604 rows & 6 columns. Column E has only
hyperlinks to URL's. I have filtered my data via column B. I tried to A-Z
Column A. When I do, the hyperlinks do not stay with the data. The mask
looks correct but when you scroll over the hyperlink you see a completely
different URL.????? Can anyone tell me how to make sure the Hyperlink keeps
the correct URL when filtering and sorting the data.




Thanks Tim for answering, hoping you're still there. I tried it and it works
with the hyperlinks that are ok, but some of my hyperlinks when you scroll
over them show as-> blocked::http:\\ before the address and those
aren't stayng intact. Any idea why I'm getting that "blocked" inserted into
my hyperlink? How can I get rid of it?

This was from yesterday so I thought it may not get answered as it is too
old so I submitted again.

So I tried it again and even though I fixed all as =Hyperlink and took all
the "blocked" out of the addresses, it's still not staying intact. Can I
send a screen shot to anyone to give a better example? Thanks!

 

[Tim Williams]

If you can make a small XL file with the same problem you can send it to me
at gmail.

timjwilliams @ the address above

Tim.