A hyperlink to a JPG file opens the image in IE, not the default p

[SteveMann]

Here’s a piece of weirdness I’ve been investigating with my spreadsheet
database.

As you doubtless know, you can put hyperlinks to a file on your hard disk
into an Excel Worksheet or Word Document. If you click on such a link then
the file will open in its associated program. Except, after an automatic
update to Office 2003 SP3.

I have a database of about 15,000 JPG photos in Excel, with a hyperlink to
each one. The Microsoft Windows Photo Gallery is the default program for all
JPG images, and opening any image from Windows Explorer does so in Windows
Photo Gallery.

Excel however, opens the linked images in the Web Browser, which is rather
annoying for a number of reasons including the resolution.

In XP I fixed this with a registry entry in
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\Internet:
DWORD ForceShellExecute = 1

But, I can't find a similar place in Vista to add this key.

Any help to fix this would be appreciated

 

[Gary''s Student]

You should not need to mess with the Registry:
1. open some folder
2. Tools > Folder Options > File Types > JPG > Advanced > and clear the
browse in same window checkbox

 

[SteveMann]

You should not need to mess with the Registry:
1. open some folder
2. Tools > Folder Options > File Types > JPG > Advanced > and clear the
browse in same window checkbox

I couldn't imagine how this could cause a hyperlink to open in IE instead of
the default program, but it was an easy try. Didn't work. By the way, in
Vista, that option from the same app is in another place.

 

[Robert McLean]

Hello
I have the same problem, except in my case I am using Windows XP, and Office 97, ( yes its old, but then so am I ), so this is not a problem new to Office 2003.

What I dont understand is that this is only affecting my links to jpg files, I also have links in spreadsheets to .gif files, and they all work correctly. That is, the gif links open with PhotoEditor just as I want them to. It is only links to jpg files that act strangely. And I checked som Word files to see how links behave there, and they do the same thing. So this may not be an Excel problem per se, but a Windows problem.

"2. Tools > Folder Options > File Types > JPG > Advanced > and clear the
browse in same window checkbox"

This check box is grayed out when I look at it, so I cannot change it, but it is deselected anyway. I dont think this is the problem.
Unfortunately, I cant check how my gif files are set up. There is no "advanced" button when I look at gif files.


"In XP I fixed this with a registry entry in
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\Internet:
DWORD ForceShellExecute = 1"

Was this an entry that was already there, and you changed the value to 1 from something else, or is this a new registry entry ?

I would be interested in hearing if any one else knows anything about this.




--

 

[Robert McLean]

Just to Update :
I added the registry key suggested (I realised it is a new key),
and this does solve the problem for me.
This confirms this works for Office 97 as well as Office 2003.

Thank you.

 

[angliron]

I've tried the solutions above, but my Excel hyperlinks to .jpg photos still
open and show up in IE8. (I didn't have this problem until I installed IE8.)
My .jpg extension is associated with Windows Picture and FAX Viewer, though
you would never guess it by the registry keys. I made the registry change
recommended above, but clicking on a hyperlink still opens IE8.

Could it be the versions of the programs I use?: Windows XP Pro, Office XP
Small Business (Offfice 10). When I associate files, I don't even have an
"Advanced" selection.

Photos in .bmp format also open in IE8 when hyperlinks are clicked. Photos
in .tif format open in MS Office Document Imaging.

angliron

 

[C]

How do you specify what browser comes up if you have a web address in the
hyperlink. I tried changing Internet Shortcut with no file extension in File
Types from Explorer to Firefox and it didn't work. Can you use Firefox? I use
2000.

 

[C]

How do you specify what browser comes up if you have a web address in the
hyperlink. I tried changing Internet Shortcut with no file extension in File
Types from Explorer to Firefox and it didn't work. Can you use Firefox? I use
2000.

 

[tryer22]

Just to Update :
I added the registry key suggested (I realised it is a new key),
and this does solve the problem for me.
This confirms this works for Office 97 as well as Office 2003.

Thank you.

I added the key as above and it solved the problem, however now when when using hyperlinks to another excel workbook from within excel it causes it to hang. I'm using xp pro, office 2000
Any idea's as I use hyperlinks to both pictures and excel workbooks a lot