Multiple hyperlinks in excel

[dpw666]

Hi all

I have a small problem with some excel worksheets that contain lots of hyperlinks.

The data that the hyperlinks refer to has moved and I need to change all the links in the worksheets to match this :

e.g

\\server1\data\img.jpg

is now located

\\server2\data\img.jpg


Can anyone help or advise ? We have thought about manually changing the links but there are too many files to change.


Thanks


Dave

 

[gizmo1973]

Try find and replace (Ctrl and H)

i.e.

find server1
replace with server2


Don't just repalce numbers, very bad things can happen!!

Regards, Phil

"If in doubt, hit it with an end user!

 

[dpw666]

Phil

Already tried the find and replace and it does find the hyperlinks, only searchs visible data.

Cheers


Dave

 

[gizmo1973]

Have you tried edit links?

Regards, Phil

"If in doubt, hit it with an end user!

 

[dpw666]

Phil

Just tried that and it doesnt pick up the hyper as a link.

On a plus note my colleague is just trying some software that does the trick.

Thanks for your post theyre much appreciated

Dave