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

Tim

"LeisaA" wrote in message
...
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?



"Tim Williams" wrote:



Try using the =HYPERLINK() worksheet function

Tim

"LeisaA" wrote in message
...
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.


.

I don't know where you're getting your links from, but this page might offer
some useful information.

http://www.slipstick.com/mail1/blocked.htm

Something is purposefully breaking your links: might be Outlook or some
other security software. Or maybe you got them already in that format.

If you remove the "blocked::" part they should work fine.

Tim


"BurgrLvr" wrote in message
...
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?



"Tim Williams" wrote:



Try using the =HYPERLINK() worksheet function

Tim

"LeisaA" wrote in message
...
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.


.