Results 1 to 7 of 7

Thread: Power Query - Hyperlink to file

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Power Query - Hyperlink to file

    I have a power query setup that imports tables from all excel files in a folder.
    Is it possible to have a column that contains a link to the original excel file?

    [I have this working in a regular excel table using the hyperlink function (which uses the customer name to get to the correct file). Now I want to convert that table to a power query table which makes automation much easier!]

    Is it possible to get this automated with power query in any way?

    Thanks,
    David

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,871
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query - Hyperlink to file

    PowerQuery doesn't support links - result will be text always
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #3
    New Member
    Join Date
    May 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - Hyperlink to file

    Ok, thank you
    Is there any workaround?

    In any case, a "No" is better than more hours wasted on trying...

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,871
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query - Hyperlink to file

    if the result of Query will be loaded into the sheet - it's possible but remeber that if you refresh your result (query)-table you will lost hyperlink.

    you can use: =HYPERLINK("link_location")
    1. add prefix: =HYPERLINK("
    2. add suffix: ")
    3. load to the sheet
    4. replace = with = (yes this is the same equal sign)
    and you'll get hyperlink but as I said above, each refresh remove hyperlink and you need repeat replace = to =
    Last edited by sandy666; Jul 15th, 2019 at 03:55 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,871
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query - Hyperlink to file

    I forgot: link_location: full path\filename
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  6. #6
    New Member
    Join Date
    May 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - Hyperlink to file

    Thanks - this worked for me.
    I created a button that runs a function to refresh the query and replace the = sign
    Works perfectly!
    Thanks

  7. #7
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,871
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query - Hyperlink to file

    You are welcome

    Have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •