Power Query - Hyperlink to file

DaveyD

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

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

sandy666

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

DaveyD

New Member
Joined
May 20, 2015
Messages
29
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
5,776
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
5,776
I forgot: link_location: full path\filename
 

DaveyD

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

Watch MrExcel Video

Forum statistics

Threads
1,102,334
Messages
5,486,223
Members
407,537
Latest member
Frank Nunez

This Week's Hot Topics

Top