Clickable URL In Excel 2007

Pat Jackson · 08-27-2009, 11:38 AM

Hey guys,

Forgive me if this is in the wrong section. I did a search for "excel" and there were a lot of threads in this section.

Basically, when I used to click a url in excel it would automatically open in whatever my default browser was, and now it's no longer doing this. Instead I have to copy and paste the address to get to the url.

I would be greatly appreciative if anyone could help me get it to do what it was initially doing again.

I'm using Excel 2007 on Vista.

Cheers!

Julian Lockhart · 08-27-2009, 11:46 AM

Click into the cell and click out. This will activate the hyperlink

or

Run a macro

see:

Hyperlink does not work when pasted or imported

Pat Jackson · 08-27-2009, 11:57 AM

Thanks for that.

I followed the instructions on that but it's still not working.

I didn't copy and paste all these links either. I entered them manually. They are all appearing as hyperlinks yet clicking on them does nothing.

Any other ideas?

Julian Lockhart · 08-27-2009, 12:06 PM

Do you get a change in your mouse pointer?
did you check to see if the hyperlink is typed correctly?

Instead of clicking try right clicking

youll see
edit HL
Remove HL
Open hyperlink

check those

Good Luck

BTW you really should post this down in the support section

Pat Jackson · 08-27-2009, 12:09 PM

Quote:

Originally Posted by Julian Lockhart

Do you get a change in your mouse pointer?
did you check to see if the hyperlink is typed correctly?

Instead of clicking try right clicking

youll see
edit HL
Remove HL
Open hyperlink

check those

Good Luck

BTW you really should post this down in the support section

As I said in the OP I wasn't sure where to post it. I'm not sure if I can move it?

Yes they are all typed correctly. I haven't edited them since they were working.

Right clicking does bring up those options, however, clicking on "Open hyperlink" doesn't do anything either. So Excel is definitely acknowledging them as hyperlinks, just failing to open them.

Julian Lockhart · 08-27-2009, 12:35 PM

Quote:

Originally Posted by Pat Jackson

As I said in the OP I wasn't sure where to post it. I'm not sure if I can move it?

Yes they are all typed correctly. I haven't edited them since they were working.

Right clicking does bring up those options, however, clicking on "Open hyperlink" doesn't do anything either. So Excel is definitely acknowledging them as hyperlinks, just failing to open them.

My bad on BTW should say YES

Check the hyperlink. it is typed correctly?

HTML Code:

http://www.yoursite.com

you also should check your default browser setting.

Pat Jackson · 08-27-2009, 12:41 PM

Default browser is all in order.

Hyperlinks are 100% typed correctly.

As I said, it has been working fine up until today. I haven't altered the links in anyway. I simply opened the file today and the links wouldn't worked.

I haven't made any changes to any part of my computer at all so I don't have any idea what's going on.

08-27-2009, 11:38 AM	#1
Pat Jackson Senior Warrior Member War Room Member Join Date: Jan 2009 Location: Melbourne, Australia Posts: 1,384 Thanks: 650 Thanked 191 Times in 129 Posts	Clickable URL In Excel 2007 Hey guys, Forgive me if this is in the wrong section. I did a search for "excel" and there were a lot of threads in this section. Basically, when I used to click a url in excel it would automatically open in whatever my default browser was, and now it's no longer doing this. Instead I have to copy and paste the address to get to the url. I would be greatly appreciative if anyone could help me get it to do what it was initially doing again. I'm using Excel 2007 on Vista. Cheers!

08-27-2009, 11:46 AM	#2
Julian Lockhart HyperActive Warrior War Room Member Join Date: Sep 2008 Posts: 142 Thanks: 66 Thanked 25 Times in 16 Posts Social Networking	Re: Clickable URL In Excel 2007 Click into the cell and click out. This will activate the hyperlink or Run a macro see: Hyperlink does not work when pasted or imported
	Sarasota Web Design Biz Launch Box - Marketing Consultant

08-27-2009, 11:57 AM	#3
Pat Jackson Senior Warrior Member War Room Member Join Date: Jan 2009 Location: Melbourne, Australia Posts: 1,384 Thanks: 650 Thanked 191 Times in 129 Posts	Re: Clickable URL In Excel 2007 Thanks for that. I followed the instructions on that but it's still not working. I didn't copy and paste all these links either. I entered them manually. They are all appearing as hyperlinks yet clicking on them does nothing. Any other ideas?

08-27-2009, 12:06 PM	#4
Julian Lockhart HyperActive Warrior War Room Member Join Date: Sep 2008 Posts: 142 Thanks: 66 Thanked 25 Times in 16 Posts Social Networking	Re: Clickable URL In Excel 2007 Do you get a change in your mouse pointer? did you check to see if the hyperlink is typed correctly? Instead of clicking try right clicking youll see edit HL Remove HL Open hyperlink check those Good Luck BTW you really should post this down in the support section
	Sarasota Web Design Biz Launch Box - Marketing Consultant

08-27-2009, 12:41 PM	#7
Pat Jackson Senior Warrior Member War Room Member Join Date: Jan 2009 Location: Melbourne, Australia Posts: 1,384 Thanks: 650 Thanked 191 Times in 129 Posts	Re: Clickable URL In Excel 2007 Default browser is all in order. Hyperlinks are 100% typed correctly. As I said, it has been working fine up until today. I haven't altered the links in anyway. I simply opened the file today and the links wouldn't worked. I haven't made any changes to any part of my computer at all so I don't have any idea what's going on.