Import hyperlink from sql server into Excel

Posted on 2012-09-13
Last Modified: 2012-09-17
I have a data connection set up to import some sql server data into excel and it works without issue. However, I want to use one of the sql server fields as part of a hyperlink. I know I can create my own column, outside of the imported data and make a hyperlink, but, I'd like to just import the function (or whatever) using the data connection.
I have something like this in one of the fields in the data connection's definition:
'=Hyperlink("https://myURL/' + mySqlField + '","' + friendlyNameField + '")'
which turns into this in the cell
The problem is that it shows up as just text in the cell (not a hyperlink). If I select that cell and hit return, it turns into a hyperlink (so I think I'm close).

any ideas?
Question by:avoorheis
    1 Comment
    LVL 17

    Accepted Solution

    Please try it like this:
        ActiveCell.FormulaR1C1 = _

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    Excel 2007 problem 2 22
    25th of every month 7 38
    Excel sheet - Calculating 4 processors ! 11 28
    Excel sending an email 5 40
    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now