#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
But I cannot open the pdf with the hyperklink in the attached sample sheet.
|
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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) |
#6
|
|||
|
|||
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" |
#7
|
|||
|
|||
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.
|
#8
|
|||
|
|||
i think the problem is your setup/permissions. the hyperlink is fine and appears to be working from what i can see.
|
#9
|
||||
|
||||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |
Excel 2011 can't open old Excel 98 or Excel X files | FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |