Solved Hyperlink How do you want to open this file?

Microsoft Excel 2010 - complete product...
December 12, 2016 at 06:58:10
Specs: Windows 10, Intel G3240/1-tetrabyte
This pop up keeps appearing when I click on any hyperlink I've created in Excel (2010) and Word (2010). The program is hi-lighted and I click the box Always use this app to open .jpeg files, but it still appears every time. I have the same set up on my laptop and it works fine. Running Win 10 on both. Anyone come across this?

See More: Hyperlink How do you want to open this file?

Report •

✔ Best Answer
December 18, 2016 at 13:01:31
Here is a program that may be of assistance:

http://www.thewindowsclub.com/file-...

See if it helps on the problem machine.

MIKE

http://www.skeptic.com/



#1
December 12, 2016 at 09:19:27
Are these hyperlinks to jpg files then, and if so what program is showing?

Let us have a copy of one of these hyperlinks but put it in quotes so that it doesn't try to activate on here.

Always pop back and let us know the outcome - thanks

message edited by Derek


Report •

#2
December 13, 2016 at 00:14:45
Hi Derek
I have a list of historic houses and castles in a column in Excel. These are to be made into hyperlinks to open the .jpeg image from a folder which contains them all. My default program is Irfanview. The hyperlink is the name of the house. The link works but only after I've told the popup which program to use and click the box to always use this program. A typical link would be "Arbury Hall " . I have since put both the Excel file and the folder containing the pictures into dropbox and edited the link. When trying it from my laptop it works fine, but my PC still the same.

Report •

#3
December 13, 2016 at 07:20:33
Just to make sure, on the operating system level,
have you Associated the target .jpg's
with IrfanView, in the properties section of the .jpg?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
December 13, 2016 at 08:27:20
Along the same lines as #3, do your jpg images open normally with IrfanView? Make sure both jpg and jpeg are associated with Irfan. To check this copy a jpg image file somewhere and rename it to jpeg. Does it still open in Irfan?

Always pop back and let us know the outcome - thanks


Report •

#5
December 13, 2016 at 08:34:20
I would expect that clicking the checkbox (for any one .jpeg file) would
be the same as associating .jpeg with IrfanView. Could the problem
possibly be anything to do with the multiple extensions .jpg & .jpeg ?

-- Jeff, in Minneapolis

PS: Derek posted while I was typing....

message edited by Jeff Root


Report •

#6
December 13, 2016 at 10:36:58
All images are .jpg files and IrfanView is associated with this extension and .jpeg and loads more. All the images open as normal when I double click them. Copied an image and renamed as suggested and it opened as normal when double clicking. I think it must be something wrong in Windows as I have no problem when clicking the hyperlink in the same file from my laptop in Dropbox.

Report •

#7
December 13, 2016 at 11:15:46
You may open it manually.

Report •

#8
December 13, 2016 at 11:32:38
Yes I can open them manually but I want to open them by hyperlinks and that doesn't solve the problem.

Report •

#9
December 13, 2016 at 12:37:21
I realise your issue is with Word & Excel (rather than Outlook) but this might still be applicable:
https://support.microsoft.com/en-gb...

Seems IE could be the culprit.

Always pop back and let us know the outcome - thanks

message edited by Derek


Report •

#10
December 14, 2016 at 04:41:28
Can you post an example of one of the links in the cell?

Report •

#11
December 14, 2016 at 09:22:43
The links work as soon as you tell it what program to use but it never remembers even when the box on the popup is ticked to always use this program.
At the moment I cannot select a best answer because the problem is still ongoing.
I shall mess about tomorrow on the link Derek gave me at support.microsoft.
Hair is beginning to drop out now.

Report •

#12
December 16, 2016 at 12:33:16
pashrefa, can you post an example of a link?

Report •

#13
December 17, 2016 at 05:24:55
In cell A1 Is the Text Arbury Hall. This is turned into a hyperlink and the address shown
in the edit box is ''Historic%20Houses%20(Pictures)\ArburyHall.jpg''
The information shown in the box when hovering the mouse over the cell is:
''file:///C:\Users\Paul\Dropbox\Historic Houses of Great Britain\Historic Houses (Pictures)\ArburyHall.jpg''. Works fine on my Laptop but not on my PC. It seems to happen on images only as I've changed the link to open Word, Excel, and Text files and no problem. Tried Microsoft support as Derek suggested did what they said. Still no good.



Report •

#14
December 17, 2016 at 07:26:09
I don't know what is going on here but the %20 in the link you gave is html for "space". As a workaround try changing the address to:
''Historic Houses (Pictures)\ArburyHall.jpg''
(note the two spaces)

Always pop back and let us know the outcome - thanks


Report •

#15
December 17, 2016 at 07:51:57
The address with the %20 in opens up no problem on my laptop because its the same
Excel file I'm using for both machines. I did take them out on my PC as you suggested. Still didn't work and the address changed back to it's original state when I clicked the box again to open it.

Report •

#16
December 17, 2016 at 08:56:50
Have you tried changing how the jpg's open?

Instead of associating the files with Irfanview
see what happens if you specify a different program,
like Windows Photo Viewer or XnView (which is Freeware).
It shouldn't make a difference, but .............

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#17
December 17, 2016 at 09:18:32
Also, have you tried a Repair on MS Office?

Click on Start
Click Control Panel.
Click Uninstall a Program.
A list of all installed programs should now appear
Select, DO NOT double click, simply highlight, MS Office
At the top of the page, you should now see Uninstall and Change buttons,
Click Change
A MS Office popup window should now appear
Select the Repair option and click Continue.

See if that helps.

MIKE

http://www.skeptic.com/


Report •

#18
December 17, 2016 at 14:54:34
Another thought,

Do you have the exact same ADD-INs and COM files running on both
versions of Excel & Word?
What about Macros?

Try running them in Safe Mode which by-passes all Add-Ins and Com files.

For Excel:

Click Start
Click Run
In the run box enter: excel.exe /s
Click OK, or press Enter.

The /s tells excel to run in Safe Mode.

Open your hyperlink file and see how it works.

For MS Word

Click Start
Click Run.
In the run box enter: winword /safe.
Click OK, or press Enter.

Open your hyperlink file and see how it works.

MIKE

http://www.skeptic.com/


Report •

#19
December 18, 2016 at 02:17:58
Thanks for the suggestions Mike Did everything you wrote and guess what? No sorry still the same. when I went to do the repair (which I had done previously from the disc) I noticed that there was still Microsoft Office Pro 2007 still listed. So I uninstalled that before I did the repair as I am running Office Home & Student 2010. I thought there might be some kind of interference from that. I should be so lucky.

Report •

#20
December 18, 2016 at 06:21:41
Ok,

So at least now we know that
changing how you open the jpgs has no effect.
doing an Office Repair has no effect
and running both Word & Excel in Safe mode was also unsuccessful.

Since the problem is affecting both Word and Excel and your using Office Home & Student, try creating a file in PowerPoint with a hyperlink to one of your files
and see if that also causes problems.

Also, update all of your drivers,
particularly your Printer drivers.
Best to go to your printers manufacturers web site and get the latest ones there
and make sure you have all the latest Windows 10 updates.
Check the optional updates also just in case.

And (reaching for straws here) both Adobe and Skype
have, in the past, caused grief with Office.
Try uninstalling them, if you can, and see what happens.

MIKE

http://www.skeptic.com/


Report •

#21
December 18, 2016 at 06:33:19
One other thought,

I do not use DropBox, so am not familiar with how it works,
all I know is that it is a file sharing application.

Try pointing your hyperlink to someplace other than the DropBox directory.
Something like:

"C:\Users\Paul\MyPics\Historic Houses of Great Britain\Historic Houses (Pictures)\ArburyHall.jpg"

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#22
December 18, 2016 at 09:08:17
Dropbox is a cloud storage facility 2gb free. I tried using this because the problem is on my PC and wanted to try Dropbox to use the same file from both machines. Tried Power Point as suggested, not using Dropbox the same thing happened. I will try the other stuff tomorrow. Thanks again.

Report •

#23
December 18, 2016 at 13:01:31
✔ Best Answer
Here is a program that may be of assistance:

http://www.thewindowsclub.com/file-...

See if it helps on the problem machine.

MIKE

http://www.skeptic.com/


Report •

#24
December 19, 2016 at 07:53:03
Thanks Mike
Finally. Problem solved. Thanks for the link.

Report •

#25
December 19, 2016 at 08:16:44
Since it was the File Association fixer that solved the problem,
I'm guessing that it was a glitch in the registry.

Glad it's finally solved.

MIKE

http://www.skeptic.com/


Report •

#26
December 19, 2016 at 10:15:50
mmcconaghy

Good find that program.

Always pop back and let us know the outcome - thanks


Report •

Ask Question