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

JNM

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


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
0


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

Splendid
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?
 
Aug 20, 2018
1
0
10
0
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.
 
Thread starter Similar threads Forum Replies Date
N Apps General Discussion 2
A Apps General Discussion 1
V Apps General Discussion 2
Z Apps General Discussion 4
I Apps General Discussion 1
XGamer_BiH Apps General Discussion 1
G Apps General Discussion 1
S Apps General Discussion 1
V Apps General Discussion 8
P Apps General Discussion 14
C Apps General Discussion 1
T Apps General Discussion 1
D Apps General Discussion 1
G Apps General Discussion 1
viveknayyar007 Apps General Discussion 0
viveknayyar007 Apps General Discussion 0
BackInBlack47 Apps General Discussion 1
D Apps General Discussion 6
A Apps General Discussion 1
A Apps General Discussion 1

ASK THE COMMUNITY

TRENDING THREADS