Avatar of bruno_boccara
bruno_boccara
Flag for France asked on

Excel 2010 Dynamic cross tab with HTTP link ?

Hello,
I have imported data from MSSQL to Excel tab.
one of the column contains an hypertext link.
when importing this data, excel does not automatically treat the data as an hypertext but as simple text.
only after focusing on the link and clicking the return tab the text become a real link.
What should I do to force Excel to treat the link as an hypertext during the import ?

the imported column is like this :
=LIEN_HYPERTEXTE("http://xxxxx.xxxx.xxxx/index.php?type=devis&OpenDevis=148231&file=contenuCaddie/maindevis.php";"148231")
Microsoft ExcelMicrosoft SQL Server

Avatar of undefined
Last Comment
bruno_boccara

8/22/2022 - Mon
Rainer Jeschor

Hi,
how did you import the data from SQL into Excel?

AFAIK you will have two options:
- Macro
- Calculated column
The macro will run through all the cells after the import and create the hyperlink, the additional column will look like
=HYPERLINK(CELLINTHISROW)

HTH
Rainer
bruno_boccara

ASKER
I inport the data using ODBC connection.
when I use a calculated column, the calculated column work.
the problem is after.

when I do a dynamic cross tab, when I click on a result, I lose the calculated column !
all my problem is here !!
ASKER CERTIFIED SOLUTION
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
bruno_boccara

ASKER
I DO NOT WANT TO USE MACRO
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck