Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2021, 05:21 AM
sharathnarayanan sharathnarayanan is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Novice
hyperlink to open pdf files in excel
 
Join Date: Jun 2021
Posts: 3
sharathnarayanan is on a distinguished road
Default hyperlink to open pdf files in excel

Hello everyone,

Need help with a formula to open pdf files for the list in excel. A sample sheet is attached for your reference.

Thanks in advance!
Attached Files
File Type: xlsx sample file.xlsx (26.4 KB, 14 views)
Reply With Quote
  #2  
Old 06-19-2021, 07:20 AM
wiganken wiganken is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

You don't need a formula if the "ClickHere For pdf" are hyperlinks. I know they look like hyperlinks but that may not be the case if they are not opening. Just click on the hyperlink, which should launch your default pdf viewer. You will likely get a security pop-up warning but 'OK' it to view the pdf. It works on my machine.
Reply With Quote
  #3  
Old 06-19-2021, 11:33 AM
sharathnarayanan sharathnarayanan is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Novice
hyperlink to open pdf files in excel
 
Join Date: Jun 2021
Posts: 3
sharathnarayanan is on a distinguished road
Default

But I cannot open the pdf with the hyperklink in the attached sample sheet.
Reply With Quote
  #4  
Old 06-19-2021, 12:16 PM
Purfleet Purfleet is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

the hyperlink appears to be working, i cant check as i dont have the file in my drive C

Is the file path correct? do you have a pdf viewer installed?
Reply With Quote
  #5  
Old 06-19-2021, 01:49 PM
Steve Kunkel Steve Kunkel is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

Also, are your pdfs really where you think they are? Your screenshot suggests that the pdf is in c:\you\documents, but your formula is looking in c:\transmittals.

Also, you are looking for a file called, "SD for Structure 01 - Guard House Tanker Discharge
", rather than "446-02-476- ... etc" (again, I'm basing this on the screenshot)
Reply With Quote
  #6  
Old 06-19-2021, 11:48 PM
sharathnarayanan sharathnarayanan is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Novice
hyperlink to open pdf files in excel
 
Join Date: Jun 2021
Posts: 3
sharathnarayanan is on a distinguished road
Default

Now the link is edited. But still cannot open the specified file. Sample worksheet attached. Please advise.
Pdf file name is "446-02-476-00452-21 SD for Structure 01 - Guard House Tanker Discharge.pdf"
Reply With Quote
  #7  
Old 06-20-2021, 04:10 AM
wiganken wiganken is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Is the problem related only to that pdf or other pdfs as well? If it is just one pdf then it may be corrupt or had the wrong file extension applied to it somehow.
Reply With Quote
  #8  
Old 06-20-2021, 07:46 AM
Purfleet Purfleet is offline hyperlink to open pdf files in excel Windows 10 hyperlink to open pdf files in excel Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

i think the problem is your setup/permissions. the hyperlink is fine and appears to be working from what i can see.
Reply With Quote
  #9  
Old 06-21-2021, 03:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline hyperlink to open pdf files in excel Windows 7 64bit hyperlink to open pdf files in excel Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Cross post hyperlink to open pdf files in excel
and
Hyperlink in excel to open specific folders
and
hyperlink to open pdf files in excel | MrExcel Message Board
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink to open pdf files in excel Windows 10 can't open excel files shiflerg Excel 2 10-27-2017 03:28 AM
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore quanghuynguyenhua PowerPoint 0 10-10-2015 06:17 PM
hyperlink to open pdf files in excel Excel Office 2010 Files will not open outside of excel stevetag Office 3 06-22-2014 07:23 PM
How can I add hyperlink to open a word file from an excel combo box selection? mahmoudramadan Excel 0 10-20-2012 10:41 AM
hyperlink to open pdf files in excel Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft