Changing hyperlink addresses (global)?
 

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

Changing hyperlink addresses (global)?
 

Wonder if this link helps.

http://groups.google.ca/group/micros...e1b2fd56e7a187

Epinn

"Ian Bersten" wrote in message oups.com...
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