HYPERLINK Function

[mikeymay]

I am using the HYPERLINK function to open a website that is held in another cell.

=HYPERLINK(AE4,AC4)

Cell AE4 is the website, e.g. U.S. Preferred ETF
AC4 is holding the Friendly Name

I am getting an error massage that says - Unable to open WEBSITE. Cannot locate the Internet server or proxy server.

I can't seem to find any solution for this which is a little frustrating for something so simple and fundamental to Excel.


TIA

 

[etaf]

whats in AE4 ?
is it the FULL website address including HTTPS://
or just a shortned text
like
website.com

otherwise Add the Https
=HYPERLINK("https://"&AE4,AC4)

 

[mikeymay]

whats in AE4 ?
is it the FULL website address including HTTPS://
or just a shortned text
like
website.com

Sorry, the posting seems to automatically changed the address into a link.

Cell AE4 holds the full web address - https//: AND the website address of www.globalxetfs.com/funds/pffd/

 

[etaf]

working fine for me here
if you click on the links above , as shown in the posts - do you get to the website OK ?

Book4
	B	C	D	E	F	G	H	I
1
2		fred		U.S. Preferred ETF				fred
3		tets		globalxetfs.com/funds/pffd/				tets
4		a		globalxetfs.com/funds/pffd/				a
5		bb		U.S. Preferred ETF				bb
6
Sheet2

Cell Formulas
Range	Formula
C2,C4:C5	C2	=HYPERLINK(E2,I2)
C3	C3	=HYPERLINK("https://"&E3,I3)

 

[mikeymay]

It tries to open the link but it comes up with the error message.

I can see you're on a Mac platform which could mean settings on the Windows platform would be different.

 

[etaf]

maybe
But can you open the webpage , if put directly into a browser ?
what browser is set as default
Windows version - also worth adding to profile

your not getting a link error , more of an internet DHCP error , not able to locate the server / proxy server

maybe a windows firewall prevent access

I'm not sure Excel uses as the default browser now - I know on older version it used IE and I think on 365 on windows 10 - last time i used it - it used Edge
But not 100% certain on that