Hyperlink to .xlsx file does not work!

Hey guys,

I have a very infuriating problem (bet you've never heard that one before!) with hyperlinking. I have created a hyperlink in a cell that looks like this:

Please Login or Register  to view this content.

Now, my file REQ0597.xlsx is located in the same folder as the the master file I'm trying to open it from (called 'REQ Generator'). In theory, the file should simply open up when I click on the hyperlink. I have tested this same setup on multiple computers at work and the file opens as expected on everyone else's computer without a hitch. I'm using excel 2013. They are on 2013 or 2010. But it doesn't work on mine. So, what happens on mine?

- I click on the hyperlink and I get a dialogue "Opening C:\Users\etc etc etc\REQ0597.xlsx Some files can contain ciruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?"

- I click on "OK"

- Excel does not open the file. I get the windows timer spinning as though it's thinking. This will run indefinitely, unless I click on something in the document. If I click, the timer goes away and nothing happens.

- Interesting behaviour in excel after this. It is almost like it's in a semi-crashed state, or there is a window somewhere which is not opening properly (there is no other window). The arrow keys stop working. i can't move around the spreadsheet any more. I also can't hit 'enter' to type in new data is that just goes to a new line in the same cell. I can edit text in cells, I just can't confirm it (or delete it).

- I have to restart excel to get out of this weird behavior.

- If the file REQ0597 is already open, then excel just simply jumps over to it with no dramas. But that's pointless for me, I need it to open the file from a closed state. But maybe it'll help troubleshoot.

- I have tested the hyperlink function with a jpg and it worked fine. Also works with websites fine too. It's just this damn xlsx format and i also tried xls and that doesn't work either.

So what have I tried?

- The microsoft fix - http://support.microsoft.com/kb/925757. It doesn't work. I have tried everything I can think of in the registry. <CLSID> doesn't exist. I made it and put in the hack. Put the hack in xlsx folders, everywhere. nothing helped.

- I've also tried this locally and on the network. I have gone to the trust centre in excel and ensured the folded is 100% trusted. I have turned every single security feature in there off. Nothing works.



If anyone can think of something else for me to try, that would be great. I have search every forum I can find and only these options pop up. Interestingly, most people don't seem to have an issue with the file not opening after they click OK. It's just me. Though i did find one other person with my exact problem but it remained unsolved. A lot of people tended to only get this virus warning message for files OTHER than excel. But I seem to only get it WITH excel. It works fine with pdf, jpg, docx. Only excel files. WHY?!?

Thanks

I was excited for a second there as I hoped a different way would result in a solution, but unfortunately it didn't work

I'm using VBA to add the hyperlink now as below:

Please Login or Register  to view this content.

It generates a brand new link each time I run the code. This coding works perfectly on everyone else's computer except for mine...

I did find some coding on getting a VBA button to do this for me instead but it's just too messy. If there was another alternative to using a hyperlink that I can put into a cell, maybe that might be helpful...

Might be worth pointing out that in my VBA code I have the following line:

Please Login or Register  to view this content.

This works perfectly. So excel is perfectly happy to open the file when it's done via coding in VBA, but just not when following a hyperlink...

Hi. I have exactly the same problem. My laptop is also the only computer that cannot open a hyperlink to an xlsx document, but xls works fine. It does not matter if the files being accessed / link to, are located on my own PC or over the network. Other computers in the company also have the same version of excel as myself. I cannot think of anything which would make my PC different from that of the others.

I am also the creator of the original excel document in which the links are being created. I was hoping that you may have obtained an answer to your problem in the mean time ?

Best Regards, and luck if you also have not solved this problem yet.

Gerhard

Is it just the one .xlsx file that Excel cannot open or will it also not open any .xlsx file?

If it is all files, then I had a similar problem with opening Excel files which was resolved by re-installing Excel. Just a thought.

Regards
Alastair

Hi Alastair

Thank you for reply. It is any xlsx file being hyperlinked. Good luck for the day