change link properties in a cell

[TennisProMaps.com]

Hello,

Our accounting software creates an excel report that contains a link
to an image. (file://H:\xxxxx\xxxx\xxxxx.tif) for example.

The problem is we want to replace the path to the image with something
that will point to a folder on a dvd for example. We will not be able
to control which drive letter the end user will use.

My questions then;

Is there a way to change the path in the link without interacting with
each one? There are well over 1000 links in each spreadsheet.

Is there a way to make the new path relative to the location of the
spreadsheet file?

Thanks so much,

k

 

[kaliman]

Perhaps you can try modifing the link by going through:
Edit
Links
Change Source