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";"14823
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";"14823
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 !!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I DO NOT WANT TO USE MACRO
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