Power Query - Hyperlink to file

DaveyD

New Member
Joined
May 20, 2015
Messages
14
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
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,315
PowerQuery doesn't support links - result will be text always
 

DaveyD

New Member
Joined
May 20, 2015
Messages
14
Ok, thank you
Is there any workaround?

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

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,315
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:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,315
I forgot: link_location: full path\filename
 

DaveyD

New Member
Joined
May 20, 2015
Messages
14
Thanks - this worked for me.
I created a button that runs a function to refresh the query and replace the = sign
Works perfectly!
Thanks
 

Forum statistics

Threads
1,078,486
Messages
5,340,616
Members
399,387
Latest member
amrita34

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top