Hyperlink hell
 

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


--
komatik
------------------------------------------------------------------------
komatik's Profile: http://www.excelforum.com/member.php...o&userid=26994
View this thread: http://www.excelforum.com/showthread...hreadid=402006

"komatik" wrote in
message ...

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.

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


--
komatik
------------------------------------------------------------------------
komatik's Profile: http://www.excelforum.com/member.php...o&userid=26994
View this thread: http://www.excelforum.com/showthread...hreadid=402006