Hyperlink hell

[komatik]

Hello,

I have an excel2000 work book with numerous worksheets. On each worksheet I have one column dedicated to hyperlinked jpgs which reside on the local drive. The hyperlinks worked great, but the images were opened up in Microsoft Picture Editor even though the jpgs are associated with Irfanview. I never use Picture Editor it and would prefer that the jpgs open up in Irfanview (or some other viewer if the workbook is shared with another user that may not have Picture Editor installed.). So I uninstalled Picture Editor and now the hyperlinks are broken (figures) even though the hyperlink is explicit ie (C:\AmlampGIS\TIL-PAT\LAP\FieldPhotos\LAP04345-16754.jpg) . Now a couple of other jpgs in the root or other folders of C:\AmlampGIS open up. What happened?? How to fix? Thanks in advance.

Cheers,
John

[Ron]

"komatik" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have an excel2000 work book with numerous worksheets. On each
> worksheet I have one column dedicated to hyperlinked jpgs which reside
> on the local drive. The hyperlinks worked great, but the images were
> opened up in Microsoft Picture Editor even though the jpgs are
> associated with Irfanview. I never use Picture Editor it and would
> prefer that the jpgs open up in Irfanview (or some other viewer if the
> workbook is shared with another user that may not have Picture Editor
> installed.). So I uninstalled Picture Editor and now the hyperlinks
> are broken (figures) even though the hyperlink is explicit ie
> (C:\AmlampGIS\TIL-PAT\LAP\FieldPhotos\LAP04345-16754.jpg) . Now a
> couple of other jpgs in the root or other folders of C:\AmlampGIS open
> up. What happened?? How to fix? Thanks in advance.
>
> Cheers,
> John

Try this.
Find one of the pictures on your hard drive that is supposed to be linked to
your workbook. Right click it and choose Properties to see what program is
associated with the file to open it. If it is Picture Editor, right click on
the file again and choose Open With and change the association.
--

--
Ron P

Just remember....if the world didn't suck, we'd all fall off.

[komatik]

Ron,

Thank you for the response. I checked the file association and jpgs are associated with Irfanview. So that I not the problem. But I have worked out a solution that is better I think. I have used the =Hyperlink function instead of inserting the hyperlink from the menus. It was pretty easy to do a replace to insert the function into the cells. This way, if the location of the jpgs changes a wholesale search and replace can be done.

Cheers,
John