Hyperlink to Files and Folders in Excel | Create Links to all Files and Sub-folders in a Folder

In this Microsoft Excel video tutorial I explain how to create hyperlinks to files and folders in Microsoft Excel. The tutorial features the HYPERLINK function and Power Query. Power Query can be used to list all the files and sub-folders within a folder.

Table of Contents:

00:00 - Introduction
00:21 - Link to a specific folder
00:57 - Link to specific file (Excel, Word pdf etc)
01:24 - Link to a specific sheet in an Excel workbook
02:15 - Link to a particular cell in another Excel workbook
03:52 - Link to a particular place in a Word document
05:00 - Create links to all files in a folder and its subfolders using Power Query and the HYPERLINK function
08:26 - Create links to all subfolders within a folder using Power Query and the HYPERLINK function
------------------------

[djl]

Copying the name of the folder in the query setting was was a GOOD IDEA!!!.

[digambarbhide]

Extremally useful video! Great job Chester. Thanks a lot. All your videos are very informative and are in simple step by step procedure. I think if the excel file is saved in the main folder then the links will work even if the entire folder is copied to other location. Any comment!

[teoxengineer]

Thank you so much for this useful tutorial.
How can we use Hyperlink function by dynamic cell reference?

[brmvltu]

Hello,
Thank you for the tuturial.
Does it also work with Google Sheets?

[vinothsekar]

Hi Tugwell, I have a data with a different ID and the adjacent column contains numerical value with respect to each ID. I receive every day these data and sometime, some of the ID will not contains numerical value in the adjacent cell. I need to find the difference of a particular ID i.e., today's data with previous data. If the previous data is blank then it has to check the next previous data which contains the numerical value. I dont know how to figure out the formula for this case.

[GokhanOrmeci]

How could we do this on 365 Excel and a Sharepoint folder?

[mechanoid]

Can you tell me how to copy a page containing multiple hyperlinks to a new workbook without the hyperlinks being stripped off the new page in the second workbook. I have this problem and it is driving me crazy!

[bovallandingham]

is there a way to do this, send the doc via email or drop the files off in something like DropBox so when downloaded by the recipient, the hyperlink still works?

[mustavogaia]

Hi, Mr. Tugwell, is there a video about automatically opening a hiperlink inside a excel spreadsheet.
My job requires that I download a good number of pdf filas by clicking on the hiperlink available in the spreasheet.
So my routine is to click on the hiperlink ans save the files in a given folder (I only need to open tham later.)
Maybe this is too much into VBA, or an ordinary app would do the trick, but I would appreciate if you go do a video showing how to do this.
Thanks. Nice video btw.

[liberatingtruthseeking]

can u call a excel or word bookmark from a folder
?

[cyrusicemansoberano]

=COUNTIFS(H17:I17, "X", F17, "Active") why it shows #value? and if this =COUNTIFS(H17, "X", F17, "Active") it works, what seems to be the problem with this Sir, I need to count the X in multiple columns, thank you in advance