How do I copy Hyperlinks from a cell in 1st workbook to another cell in the 2nd workbook?

[JNM]

I can use the copy/paste special (paste link) to transfer the link to the next workbook, but when I go to open the hyperlink in the 2nd workbook it says "Cannot open specified file". Excel even colors it blue, like it is active. Any suggestions would be greatly appreciated. Thanks, John

 

[USAFRet]

Don't Paste Special. Just paste.

Paste special (paste link) creates a link back to that original workbook, not to the hyperlink

 

[JNM]

Don't Paste Special. Just paste.

Paste special (paste link) creates a link back to that original workbook, not to the hyperlink

Thanks, I will try this and let you know how it turns out for me.

I tried using the paste method that you suggested but I still get the same message. I also verified that the link in book 1 does work and open up. When copied over to the next book, the command becomes invalid.

 

[Alabalcho]

Where does the original hyperlink points to? Is it an URL like http/www.yahoo.com, or is a link to another workbook?

 

[JNM]

Where does the original hyperlink points to? Is it an URL like http/www.yahoo.com, or is a link to another workbook?

The link originally comes from a file off of the company network system. From there I hyperlinked it to the excel sheet by using the insert hyperlink box. Since I work several workbooks, requiring same hyperlink, I wanted to use this method (if possible), without using the network because it requires a lot time to bring up the file. Yes, it is being used from another excel workbook.

 

[USAFRet]

Don't Paste Special. Just paste.

Paste special (paste link) creates a link back to that original workbook, not to the hyperlink

Thanks, I will try this and let you know how it turns out for me.

I tried using the paste method that you suggested but I still get the same message. I also verified that the link in book 1 does work and open up. When copied over to the next book, the command becomes invalid.

CTRL-C (workbook A)
CTRL-V (workbook B)

I just tried it. It works...2 completely different workbooks.
What version of Excel are you using? I'm on 2013.

This is a regular www. hyperlink?

 

[pclive]

I know this is an old post, but I wanted to add that if your destination workbook is shared, then the hyperlinks will not copy over.