Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 21st 10, 09:03 PM posted to microsoft.public.excel.worksheet.functions
Bod Bod is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 17
Default Paste Hyperlink result as working hyperlink

Hi! I have a column of over 700 filepaths.
I have a column which turns those paths into hyperlinks:
=hyperlink("http://tbuk/"$B3)
These links work.
I want a single column that doesn't refer to the filepath, so I am trying to
replace the hyperlink formulae with the result as a hyperlink.
When I copy and paste, it seems to paste the result, but the link doesn't
work (though it still has the style of a link: blue underlined).
Is there a way to avoid having to press F2, Enter for every one?

  #2   Report Post  
Old January 22nd 10, 05:16 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 277
Default Paste Hyperlink result as working hyperlink

On Thu, 21 Jan 2010 12:03:01 -0800, Bod
wrote:

Hi! I have a column of over 700 filepaths.
I have a column which turns those paths into hyperlinks:
=hyperlink("http://tbuk/"$B3)
These links work.
I want a single column that doesn't refer to the filepath, so I am trying to
replace the hyperlink formulae with the result as a hyperlink.
When I copy and paste, it seems to paste the result, but the link doesn't
work (though it still has the style of a link: blue underlined).
Is there a way to avoid having to press F2, Enter for every one?



If you get a finger pointer mouse cursor change when you hover over it,
it is a hyperlink, and should evoke your browser, regardless of whether
it is even a valid link or not, and try to "go there"..

So try it. Paste in a valid directory pointer as a link and see if it
will take you there. If so, then maybe there is a problem with the pasted
link syntax somehow with your data set.
  #3   Report Post  
Old January 22nd 10, 05:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 277
Default Paste Hyperlink result as working hyperlink

On Thu, 21 Jan 2010 12:03:01 -0800, Bod
wrote:

Hi! I have a column of over 700 filepaths.
I have a column which turns those paths into hyperlinks:
=hyperlink("http://tbuk/"$B3)
These links work.
I want a single column that doesn't refer to the filepath, so I am trying to
replace the hyperlink formulae with the result as a hyperlink.
When I copy and paste, it seems to paste the result, but the link doesn't
work (though it still has the style of a link: blue underlined).
Is there a way to avoid having to press F2, Enter for every one?



Right click on one and select "edit hyperlink" and see what the actual
hyperlink syntax is there, because the visible string can say "up-yers"
and the inside is where the real pointer is at so the "link" takes you to
a different place than the actual text that appears.

That is so you can name the link, as in "Go To Home Page" or such, and
the underlying true link is the one that actually gets referred to.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to PDF not working Tim Excel Discussion (Misc queries) 1 November 12th 09 02:32 PM
VLookup result to be an active hyperlink Kapplox Links and Linking in Excel 1 January 18th 07 05:30 PM
Hyperlink not working... neilcarden Excel Worksheet Functions 1 June 22nd 06 09:10 AM
Excel hyperlink not working Jim Excel Discussion (Misc queries) 0 November 28th 05 04:23 PM
Hyperlink stops working Jami's Mom Excel Worksheet Functions 0 December 20th 04 06:17 PM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017