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.

"Tim Williams" wrote:

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" wrote:

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.

"Tim Williams" wrote:

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.


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!

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.


"BurgrLvr" wrote in message
...


"BurgrLvr" wrote:

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.

"Tim Williams" wrote:

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.


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!