•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying EVERYTHING. I need a drop down list to allow for clickable hyperlinks to external websites.
Our take
It sounds like you're navigating a common challenge with drop-down lists and hyperlinks in spreadsheets. While your current setup allows for selecting report names via data validation, the hyperlinks unfortunately revert to plain text. To address this, consider creating a separate column using the `=HYPERLINK` function, but ensure the syntax is correct to avoid errors when opening the links. You can maintain concise display text by using shorter, meaningful names alongside the longer URLs.
Ok. So I have the drop down list created through data validation (="Report Lists'!$A$1:A$40). It allows me to select the external report names which have embedded URL's. The problem is, it clears the hyperlink on the drop down and makes it plain text.
So... What I've found, is to create a =HYPERLINK column next to the drop downs. The problem with that however, is it states "Cannot open the specified file" as it tries to open the text instead of the embedded hyperlink. I cant just directly use the web address as the text name because they are super long, undistinguishable web address names.
Any help please?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#hyperlink#drop down list#HYPERLINK function#data validation