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

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

"TennisProMaps.com" wrote:

> 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
>