Changing hyperlink addresses (global)?

[Ian Bersten]

Hello group,

I got an excel sheet with a large number of links to pictures.
Unfortunately, the chap who created the sheet entered the links as
absolute addresses (say, a:\bbb\ccc\xyz.tiff), and the links refer to a
drive that doesn't exist on my own computer.
This is obviously a nuissance, I want to just use the hyperlink base
address in the properties part.
Question, how do I change the absolute adresses, "stripping" the drive
letter and superfluous directory info from the links?

Thanks for you help.

Cheers,

Ian

 

[Epinn]

Wonder if this link helps.

http://groups.google.ca/group/micro...nk+global+Excel&rnum=2&hl=en#c1e1b2fd56e7a187

Epinn

Hello group,

I got an excel sheet with a large number of links to pictures.
Unfortunately, the chap who created the sheet entered the links as
absolute addresses (say, a:\bbb\ccc\xyz.tiff), and the links refer to a
drive that doesn't exist on my own computer.
This is obviously a nuissance, I want to just use the hyperlink base
address in the properties part.
Question, how do I change the absolute adresses, "stripping" the drive
letter and superfluous directory info from the links?

Thanks for you help.

Cheers,

Ian