Excel Hyperlink Issues

zanaamr

Commendable
Dec 3, 2016
3
0
1,510
0
I have nearly around 200 hyper-links in my excel sheet and casually all the hyper-links were automatically stopped from working and the exact path has changed, can you please provide me with a solution? thanks in advance,
 

zanaamr

Commendable
Dec 3, 2016
3
0
1,510
0


Yes, the file structure has been changed. For example, at the first time i created the hyperlink for some files in D drive so that when you were clicking the specified cell it was directly taking you the D:/.../... , but the "path" has been changed from D to C and i don't know what is the problem? in addition, it is not only 1 hyperlink that's corrupted, all the other hyperlinks have the same issue. Hope it is clear
 

Phillip Corcoran

Splendid
Moderator
Seems clear enough.

The physical drive letter or partition letter has changed since those hyperlinks were created, though I can't say why (unless someone has moved the target files).

If that's all that has changed in the hyperlink path, simply edit the hyperlinks (change 'D' to 'C'), or move the target files back to where they were originally on drive D.

Incidentally, I wouldn't class this as "corruption". It's just an incorrect path for whatever reason.
 

zanaamr

Commendable
Dec 3, 2016
3
0
1,510
0



Thank you dear Phillip, appreciate your answer.
 
Thread starter Similar threads Forum Replies Date
henrytcasey Apps General Discussion 0
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
N Apps General Discussion 2
L Apps General Discussion 5
B Apps General Discussion 4
A Apps General Discussion 1
V Apps General Discussion 2
I Apps General Discussion 1
G 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
A Apps General Discussion 1
A Apps General Discussion 1
jnkweaver Apps General Discussion 5

ASK THE COMMUNITY