Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Some web-links not working in Excel


  • Please log in to reply
12 replies to this topic

#1 Johnaldo

Johnaldo

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 28 February 2014 - 03:42 AM

Hi all,

 

I have a problem with an Excel spreadsheet that I created some time ago. 

 

In it are quite a number of links to various web pages. These were created by simply copying the URL and pasting it into a cell.

 

Some of the links work fine, and open the web-page.  But some throw up the error message "Unable to open xxxxxxxxx. The internet site reports that the site you requested could not be found (HTTP/1.0 404)".

 

But I know the link is a valid one, because if I copy it from the cell and paste it into the address bar - it works!

 

Any ideas please?

 

John


Edited by Johnaldo, 28 February 2014 - 07:03 PM.


BC AdBot (Login to Remove)

 


#2 chrisd87

chrisd87

  • Members
  • 811 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NC
  • Local time:09:00 AM

Posted 28 February 2014 - 03:05 PM

Try this:

http://support.microsoft.com/kb/218153/en-us

 

Also I bet it works if you use another browser. My guess is you're using IE?


"Like car accidents, most hardware problems are due to driver ɹoɹɹǝ."

 


#3 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 28 February 2014 - 07:41 PM

Thanks for the reply Chris.

 

I used IE until about a year ago, before switching to Firefox.  But both browsers give me the same problem.

 

I didn't think it was a registry setting, because why would it affect some links and not others? However, I did make the changes as suggested, but it made no difference.

 

John



#4 chrisd87

chrisd87

  • Members
  • 811 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NC
  • Local time:09:00 AM

Posted 28 February 2014 - 08:55 PM

if you type in a new url into excel and try to open it, does it allow you to? Try adding an / to the end of the url in the excel cell that contains the link.


"Like car accidents, most hardware problems are due to driver ɹoɹɹǝ."

 


#5 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 01 March 2014 - 07:10 AM

Chris,

 

Some URLs end in a forward slash, and some do not.

Some URL links open, and some do not.

But here is no correlation between these 2 circumstances!

 

I never actually type a URL into a cell - I just copy and paste it from the address bar. 

When I enter a new URL in a cell  - sometimes it works and sometimes it doesn't!

 

John



#6 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 01 March 2014 - 12:11 PM

PS 

 

When I copy any of the non-working links from Excel, and then paste them into Firefox's address bar - they do work! 

 

So must be Excel that's causing the problem, not the URL itself.

 

Perhaps it's some sort of formatting in Excel?

 

John



#7 chrisd87

chrisd87

  • Members
  • 811 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NC
  • Local time:09:00 AM

Posted 01 March 2014 - 05:18 PM

Is the property style set to Hyperlink? Also try using the =hyperlink worksheet function and see if it works.

 

Something like this: =HYPERLINK("http://www.google.com/","Click me to go to google")

There is a comma after the " and before the " in Click


Edited by chrisd87, 01 March 2014 - 05:37 PM.

"Like car accidents, most hardware problems are due to driver ɹoɹɹǝ."

 


#8 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 01 March 2014 - 05:59 PM

Chris,

 

Not sure how to check out the property style.  I tried >Format >Style >Style Name which was "Hyperlink" - is that it?

 

As suggested, I also tried the  =hyperlink function ... again without success!

 

John


Edited by Johnaldo, 01 March 2014 - 06:12 PM.


#9 chrisd87

chrisd87

  • Members
  • 811 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NC
  • Local time:09:00 AM

Posted 01 March 2014 - 06:40 PM

may of found a solution. If you're running Windows 7, click on start-default programs-associate a file type with a program. Scroll down to the protocols and look for http. The description will say URL:HyperText Transfer Protocol. Make sure the default is Internet Explorer. If not, click Change Program, and find Internet Explorer. Same goes for https too. There should be the e logo beside http and https.

 

Also, in the spreadsheet make sure the link is set to Text and not General.


Edited by chrisd87, 01 March 2014 - 06:42 PM.

"Like car accidents, most hardware problems are due to driver ɹoɹɹǝ."

 


#10 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 01 March 2014 - 07:38 PM

Chris,

 

I'm actually running Vista, so I went to Control Panel, Default Progs, Associate File Type, and changed both HTTP and HTTPS to IE  ... but no success, so changed them both back to Firefox.

 

All the links are set to General ... some work, some don't.  I tried setting one that doesn't work to Text, but it made no difference.

 

John



#11 Johnaldo

Johnaldo
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:03:00 PM

Posted 08 March 2014 - 11:59 AM

Does anyone have more thoughts on this?  - it's driving me mad!

John



#12 chrisd87

chrisd87

  • Members
  • 811 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NC
  • Local time:09:00 AM

Posted 08 March 2014 - 12:47 PM

make you a test spreadsheet and type in the weblinks or copy/paste them and see if the test spreadsheet works.


"Like car accidents, most hardware problems are due to driver ɹoɹɹǝ."

 


#13 senseless

senseless

  • Members
  • 56 posts
  • OFFLINE
  •  
  • Local time:09:00 AM

Posted 16 March 2015 - 04:28 PM

OK, so it's been a whole year since OP, but I am having the same issue with Excel 2013, windows 8.1, and found this thread while seeking a solution.

I find the same inconsistency, when I copy/paste a link directly from the browser address bar into my spreadsheet, sometimes it becomes a live hyperlink all by itself.  And sometimes it doesn't.

Regarding the dead links I discovered this.  Right click on the cell, look for the word "hyperlink" and click it, then a window called "insert hyperlink" should appear.

At the top you will see a field called "text to display" which should match the non-functioning link in your spreadsheet.  Copy it right from there, then paste it into the field at the bottom of the window called "address".  That should do it.  I will add info if I discover what widget to fondle that makes this tedium all go away.

 

bad%20link.jpg

 

 

 

 

 

 

 

OK, this just happened with my spreadsheet.  If I double click, (left double click), the DEAD link in the spreadsheet, then click on another cell, the dead link becomes active.

Wow!  After that, only a single left click is needed to open the link in my default browser.


Edited by senseless, 16 March 2015 - 04:35 PM.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users