Excel 2007 hyperlinks opens Internet Explorer, rather than default picture viewer

Hi,

I have an annoying problem in excel 2007 that I would love some assistance on. I have an excel 2007 spreadsheet with hundreds of hyperlinks to jpg photos in it. I have set the default program in Excel as windows picture viewer, and thats the program that opens jpg's everywhere on my PC. However within excel hyperlinks are opened in Internet Explorer 8.

I have searched the web and a solution has been posted several times to add the below registry key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet]"ForceShellExecute"=dword:00000001

I have tried this, restarted excel, and restarted windows 7 but it has not resolved my issue. It seems that this issue resolves the problem in earlier versions of Windows and Excel, but not the combination of Windows 7 and IE8.

2) Others were suggesting this was an issue with IE8 itself, so I have now completely uninstalled IE8 (I use firefox so don't need it anyway). Now when I try to open a hyperlink in excel 2007 I get the error "No program is registered to open this file".


This is super frustrating, can anybody assist?

If I am not mistaken, your problem is the office version in the registry key. You said that you are using Excel 2007 and the registry key refers to Office 9.0, which is Office 2000. The path in the registry should refer to Office 12, which is the same as Office 2007. Also note that Office 13 was skipped for superstitious reasons so Office 14 is the same as Office 2010.