Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
automate hyperlink | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |