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

Status
Not open for further replies.

JNM

Estimable
Dec 16, 2014
4
0
4,510
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
 

JNM

Estimable
Dec 16, 2014
4
0
4,510


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.
 

JNM

Estimable
Dec 16, 2014
4
0
4,510


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

Illustrious
Moderator


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?
 
Status
Not open for further replies.