active hyperlinks

%3CLINGO-SUB%20id%3D%22lingo-sub-2226990%22%20slang%3D%22en-US%22%3Eactive%20hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2226990%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20a%20file%20that%20has%20URL's%20and%20the%20text%20for%20the%20URL's%20are%20not%20active%20hyperlinks%20I%20can%20click%20on.%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20all%20of%20the%20URL%20text....%20active%20hyperlinks%20for%20the%20whole%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2226990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2227646%22%20slang%3D%22de-DE%22%3ESubject%3A%20active%20hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2227646%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1004417%22%20target%3D%22_blank%22%3E%40zachbu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20correctly%2C%20you%20have%20downloaded%20a%20file%20and%20cannot%20activate%20the%20hyperlinks.%3CBR%20%2F%3EThis%20information%20further%20down%20could%20maybe%20help%20you%20further.%3CBR%20%2F%3EAlthough%20it%20actually%20needs%20more%20info%20from%20your%20side.%20Which%20date%2C%20which%20Excel%20version%2C%20which%20operating%20system%2C%20encrypted%20file%20or%20not%20...%20There%20are%20many%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20usually%20due%20to%20Internet%20Explorer%3A%20The%20requested%20information%20cannot%20be%20downloaded%20...%20Word%20and%20Excel%20no%20longer%20open%20hyperlinks%20...%3C%2FP%3E%3CP%3EAnyone%20who%20uses%20the%20automated%20data%20import%20in%20Excel%2C%20especially%20%22Data%20-%20from%20the%20Web%22%2C%20will%20most%20likely%20receive%20the%3C%2FP%3E%3CP%3EError%20message%3A%20%3CBR%20%2F%3E%20https%3A%20%2F%2F%20.........%20could%20not%20be%20opened.%20The%20requested%20information%20cannot%20be%20downloaded.%3C%2FP%3E%3CP%3EWell%2C%20in%20my%20country%20as%20we%20say%2C%20good%20advice%20is%20expensive%20because%20it%20is%20probably%20an%20Internet%20data%20source%20that%20you%20absolutely%20want%20to%20have%20imported%20into%20Excel.%3C%2FP%3E%3CP%3EThe%20background%20to%20the%20error%20message%20is%20a%20built-in%20protection%20in%20Internet%20Explorer%2C%20preventing%20encrypted%20pages%20from%20being%20saved.%3C%2FP%3E%3CP%3EWhere%20do%20we%20find%20these%20attitudes%3F%20In%20the%20Internet%20options%20of%20IE%20on%20the%20%22Advanced%22%20tab.%3CBR%20%2F%3EIn%20the%20lower%20area%20of%20the%20%22Advanced%22%20tab%2C%20there%20is%20a%20checkmark%20next%20to%3A%3C%2FP%3E%3CP%3E%22Do%20not%20save%20encrypted%20pages%20on%20the%20data%20carrier%22.%20This%20entry%20prevents%20e.g.%20HTTPS%20(encrypted)%20pages%20from%20being%20saved%20on%20your%20computer.%20When%20importing%20into%20Excel%2C%20these%20pages%20are%20cached%2C%20hence%20the%20error%20message.%3C%2FP%3E%3CP%3EAfter%20you%20remove%20the%20hook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I downloaded a file that has URL's and the text for the URL's are not active hyperlinks I can click on.

How can I make all of the URL text.... active hyperlinks for the whole sheet?

4 Replies

@zachbu 

If I understand correctly, you have downloaded a file and cannot activate the hyperlinks.
This information further down could maybe help you further.
Although it actually needs more info from your side. Which date, which Excel version, which operating system, encrypted file or not ... there are many questions.

 

This is usually due to Internet Explorer: The requested information cannot be downloaded ... Word and Excel no longer open hyperlinks ...

Anyone who uses the automated data import in Excel, especially “Data - from the Web”, will most likely receive the

Error message:
https: // ……… could not be opened. The requested information cannot be downloaded.

Well, in my country as we say, good advice is expensive because it is probably an Internet data source that you absolutely want to have imported into Excel.

The background to the error message is a built-in protection in Internet Explorer, preventing encrypted pages from being saved.

Where do we find these attitudes? In the Internet options of IE on the “Advanced” tab.
In the lower area of ​​the “Advanced” tab, there is a checkmark next to:

“Do not save encrypted pages on the data carrier”. This entry prevents e.g. HTTPS (encrypted) pages from being saved on your computer. When importing into Excel, these pages are cached, hence the error message.

After you remove the hook.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE thanks for the reply.

 

It's a CSV file I got from a list provider, a list of records that include links to the contact's websites.

I'll be using the list as a CRM and call the contacts.

Photo attached.

I'm using Excel-Web version on Edge or Chrome on Windows10 (although the formatting looks the same, no active hyperlinks, on the desktop Excel app), not encrypted.

 

The same CSV file when viewed online on Google Sheets has the URLs formatted as hyperlinks so i was hoping Excel-web did the same thing.

 

Does that help to better answer?