Hyperlink in Excel - (Magical Trick to hyperlinks 1000s of files within seconds)

[@96seya]

A round of applause for this legend. I'm sure he's saved us countless hours!

[@CoreConcepts]

Ultimate info, Watching your video after 4 years

[@earlymorningproductions9355]

Thank you. It took me a few tries, but this is working now! Very nice, thanks for your efforts.

[@metanoya9695]

i love the tutorial,, im a basic user,, this helped me a lot, thank you!

[@rogermathura]

Excellent, thanks very much. Was exactly what i was looking for to link my IC list to the datasheet pdfs. I just had to make sure the datasheets had same exact name of the IC.

[@chaynamodi3756]

Thank for making such a knowledgeable video as it saves lot of time. Thank you again.

[@mohammadsharoozqureshi9399]

Thank you for your video really It helps allot,🎉

[@manoshikadamunugolla5900]

Thank you so much. It was really helpful. Great work.

[@wwearmandoma]

This is a great video. Thank you very much

[@brahimnb-fi8yb]

Excatly what i was looking for, thanks

[@yenzapanta9696]

This is very helpful to me. I was able to create it too perfectly. But, what I need next is to make a copy of this improvised system to other computer. I perfectly understand that I have to change the path file where it will get the files I need. But still it doesn't work with MacBook. Do you have an idea if the path file in Windows OS and MacBook path file can work in excel the same?

[@xin2yu976]

Thank you so much, what if I want to hyperlink different type of file EG pdf or jpeg with 1 hyperlinks formula? Is it possible?

[@zaidahmedgulamrasul2335]

Thank you dude, it's very helpful.... great work

[@waelsaadwaelsaad6565]

Dear thank you very much this but i am asking can we doing this with multi folders inside it PDF's because in my work i need to make hyperlink with multi folders inside each one more that one PDF THANK YOU VERY MUCH

[@MicrosoftOfficeTutorials]

Yes this is also possible

[@kaganbaydar1050]

Very useful, thank you

[@khalidalmaeeni9980]

Thank you 🙏 so helpful

[@maneeshnarang9091]

Really helpful. Thanks a lot

[@abhisheksharma4340]

Hello, great job i was just looking for this. Can you please tell me if it also possible to use drive (onedrive or Google drive) instead of system folder to do this job ? Anyhow?

[@abhisheksharma4340]

An add on named dropspread is available for Google sheets. But i want to do it in excel. Can you help ?

[@Rajnibala-sf4hj]

I have really important question:- i created a main folder under that folder i created 1 excel file and one subfiolder where i am putting my pdf file whose link i am creating in excel, now when i create link using insert option then link, and if i copy the main folder to diffrent location links are working fine but from any other method it wont, please help

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@tutsecret499]

What if I want to grab text from each file and place on the current sheet. Example. Let's say all these files destination has 1 row with person name or number and 2nd column has another text or number. I want to the excel copy the row from each file and place on the current. It's like I am colating all the employees in the current sheet(combined staff). So employee 1 would be on row 1, employee 2 would be on row2 and forth. After all is colated. I will have values to count that is on column 2, row 1 or row 2 and so forth. Can you do a video like that. It's just like I am opening each file copying the whole row 1 and pasting on a next workbook.

[@MicrosoftOfficeTutorials]

Coming soon

[@yenzapanta9696]

Do you have a video wherein this formula will be made in an excel using MacBook laptop? I badly need to see if it will work the same in Windows OS PC

[@MicrosoftOfficeTutorials]

Sorry, don't have

[@indahreizkia708]

Thanks for this

[@dianavinasco-duque7911]

Thank you for this tutorial! It is very useful. I just found a problem. I want to do the data validation with the name of my files. They way you show at end of the video. But when I select it to place Source, always pop up a window saying: This type of reference cannot be used in a data validation formula. Change the reference to single cell, or use the reference with a worksheet function, such as= SUM(A1:E5). What do you recommend to do. Or should I make a new column with numbers? Thank you. I will appreciate if you can help me!

[@leborefilwe5112]

How will I know if a certain off file is missing , can the hyperlink formula have an exception to return file not found ?

[@sonalpal9332]

Thanks bro😁😁

[@nkowk]

Excellent !

[@nayazahmedahmed6323]

Excellent

[@MicrosoftOfficeTutorials]

Thanks

[@naumanfarooq4949]

You are awesome dear.

[@MicrosoftOfficeTutorials]

Thank you brother

[@MicrosoftOfficeTutorials]

You may subscribe our this channel too, to learn MS Office in Hindi / Urdu KZbin.Com/UrduHindiLectures

[@naumanfarooq4949]

@@MicrosoftOfficeTutorials Please Make a video on having a single sheet taking effect or updates of multiple workbooks automatically.

[@MicrosoftOfficeTutorials]

Don't understand exactly what you mean

[@naumanfarooq4949]

@@MicrosoftOfficeTutorials Please Make a video about a workbook in Microsoft Excel getting updated automatically from multiple workbooks. Got it ???

[@didierhardy5231]

Hello, is it possible to have the files to better understand the tutorial? (ZIP format) Thank you

[@MicrosoftOfficeTutorials]

Please provide your Email id

[@abdurrahmanjaved4814]

What is the files format has mixed with pdf and jpeg even so i will work? Because you have write pdf in formula

[@MicrosoftOfficeTutorials]

You need to use the same format as your fjle that you want to link in Excel

[@Tat-cx1lr]

Bravo et merci

[@MrJack-qu9ej]

Ek excel ka cell refer karna hai different excel mein with the use of hyper link.... So how can we do that

[@m.sspeckyy7494]

How can i do the same thing but linking text in excel list (in your example 11003) to a work sheet in the same document and not to a pdf file?

[@MUHAMMADSALEEM-pc7rh]

i had apply your define procedure but not success and message receive form MS Excel that requested file could not be found.

[@chandrabhansharma22]

Sir excel m kisi word ki file ho hyperlink se attech kiya h Or excel m salary ke total m change kare to jo word hyperlink h us m only salary m hi automatic change kese hoga math or English m

[@mr.write1433]

works only on jpg and pdf ?

[@Matawfik]

Thank you for this video, But why if copy the excel file (with hyperlink functions) + all linked files to another PC , The links do not work

[@MicrosoftOfficeTutorials]

Files path woupd not be the same as it was in old PC. Please check if it is same or no

[@ravikiranshirke9288]

I have done this step but not able to open file while using click here to open

[@jahanzaibshahid9372]

PLZ INFORM HOW TO CHANGE EXCEL SETTING FOR GO TO LINKED CELL DESTINATION BY USING MOUSE SINGLE CLICK INSTEAD OF USING KEY BOARD SHORT CUT CTRL+[ .

[@rashim7637]

Hi Is there any option for remain blank or not applicable if no pdf copy

[@gayanpriyadarshana1326]

i have some error message as "Cannot open the specified file" . please help to me.

[@ronprathima]

Hi I want these links to be accessible for my team members. But when i share the excel with them it says Cannot open the file

[@dineshpatel-sk8rv]

what if the format of photos are different? like one is jpg other is jpeg how to create hyperlink formulae to open Excat photo

[@qutubranalvi203]

Very well explained and i already used it

[@cavinbalamurali1130]

Another solution is, go to the folder and select all and do right click holding shift key and copy as paths and then paste the paths in a excel sheet. Same results in a sec

[@ajlaghogho]

Wow! @cavin balamurali Thank you so much for sharing this. This is the simplest approach so far I have seen.

[@hanisiam7552]

Hi , thank you good job , but how i can link excel with folder by hyperlink

[@sayeed110575]

Sayeed Shaikh 1 second ago To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command ECHO OFF DIR/B>A.TXT EXIT ,

[@abhisheksrivastava64]

Hi... I want to send separate cards to 500 persons with their names... I have created Excel Sheet with Name & E-mail... Now I want to prepare attachment link in front of all person... so that i can send mail with the help of Outlook... but I dont know how to create bulk link of attachment... Please help me... It is urgent...

[@Arclight24]

What is the maximum no. Of excel workbooks that can be linked to a master excel workbook? Thanks

[@sayeed110575]

Sayeed Shaikh 1 second ago To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command ECHO OFF DIR/B>A.TXT EXIT ,

[@anishkumar6267]

How to do this in excel vba userform???

[@olgamonica3805]

I tried but i can't change my hyperlink, it always direct to the same file. Anyone can help me?

[@mohamedshalik8791]

I tried the same but when I am concatenating drop down list with address it's not changing automatically

[@sayeed110575]

Sayeed Shaikh 1 second ago To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command ECHO OFF DIR/B>A.TXT EXIT ,

[@sayeed110575]

To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command ECHO OFF DIR/B>A.TXT EXIT ,

[@biswajitray5850]

how to download diferent list of files from google drive providing such employee id

[@sayeed110575]

Sayeed Shaikh 1 second ago To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command ECHO OFF DIR/B>A.TXT EXIT ,

[@marctaggart7222]

So why does excel change my link from C:\myfiles to roaming app data roaming appdata roummaing app data users roaming users whatever why on earth cant I put a link in excel and have it stay to the link I put I just can not fathom why this is the way it is !

[@marctaggart7222]

No person knows why. there has to be a way to communicate with excel to tell it HEY DONT CHANGE THIS LINK

[@kvp1987]

How to hyperlink if saved .pdf file name is longer than cell text?

[@MicrosoftOfficeTutorials]

Sorry i don't understand what you mean

[@MicrosoftOfficeTutorials]

Please can you explain a little more??

[@kvp1987]

Microsoft Office Tutorials I have files in folder with name 1_filename1_date.pdf, 2_filename2_date.pdf etc... in excel column I enter only the filenames as filename1, filename2 etc.. how to hyperlink filenames to respective files stored in the folder ?

[@manishlal795]

There are many type of files in one folder say word file, excel file and pdf file and I want to choose only pdf files how should I attach or choose only pdf file in path. Suppose I have folder in desktop which file path is this.... C:/desktop/folder/.Doc, .xls and .Pdf files How should I choose only . pdf files Please ans.....

[@farhankhan3994]

Sir I'm farhan from Pakistan, I need to creat a excel sheet for vehicle spare parts inventory. I have more than 5000 items in store and issues the items to different vehicles. I want to keep record all data in one sheet. But when I need to check the parts to which vehicle issued , it shows all the details with vehicle no. Plz help me

[@arifulislam2932]

Pleace Share the excel file

[@thangaveluraj5366]

Excellent!

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.