SOLVED

Excel Hyperlink to PDF

%3CLINGO-SUB%20id%3D%22lingo-sub-1541970%22%20slang%3D%22en-US%22%3EExcel%20Hyperlink%20to%20PDF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541970%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excel%20365%20Users%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20a%20project%20and%20the%20folder%20containing%20Excel%20and%20PDFs%20are%20saved%20to%20my%20local%20drive%20(laptop)%2C%20since%20in%20prior%20Office%20version%20preserve%20the%20links%20and%20spreadsheet%20to%20share%20with%20my%20Team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20after%20using%20the%20same%20method%2C%20I%20opened%20the%20folder%20and%20spreadsheet%20this%20morning%20and%20have%20lost%20all%20hyperlinks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20preserve%20a%20hyperlinked%20pdf%20in%20Excel%3F%26nbsp%3B%20I'm%20getting%20the%20following%20error%20message%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RayZ1965_0-1595522618452.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207479i3401CD7CF0928E0C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22RayZ1965_0-1595522618452.png%22%20alt%3D%22RayZ1965_0-1595522618452.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541970%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546245%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Hyperlink%20to%20PDF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546245%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738015%22%20target%3D%22_blank%22%3E%40RayZ1965%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20a%20bit%20unsure%20about%20how%20you%20are%20doing%20this%2C%20but%20since%20you%20plan%20to%20share%20the%20document%20out%20to%20your%20team%20and%20you%20are%20embedding%20local%20links%20from%20your%20computer%2C%20wouldn't%20that%20cause%20an%20issue%3F%20If%20it%20fits%20your%20needs%20you%20can%20try%20embedding%20the%20pdf%20documents%20as%20objects%20in%20excel.%3C%2FP%3E%3CP%3ERef%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fembed-pdf-file-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fembed-pdf-file-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547890%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Hyperlink%20to%20PDF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547890%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F67895%22%20target%3D%22_blank%22%3E%40harveer%20singh%3C%2FA%3E%26nbsp%3BThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHistorically%20(prior%20Office%20versions)%2C%20I%20link%20the%20pdf%20to%20the%20spreadsheet%20and%20save%20both%20Excel%20and%20PDF%20in%20the%20same%20folder.%26nbsp%3B%20If%20I%20share%20it%20with%20someone%20else%2C%20I%20zip%20the%20folder%20and%20e-mail%20it%20to%20a%20team%20member.%26nbsp%3B%20As%20a%20precautionary%20measure%2C%20I%20embedded%20the%20pdf%20to%20avoid%20losing%20my%20work%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20the%20hyperlinks%20are%20not%20working%20after%20I%20save%20the%20Excel%20and%20PDF%20in%20the%20same%20folder.%26nbsp%3B%20The%20following%20day%2C%20I%20go%20back%20to%20the%20hyper%20link%20and%20get%20the%20error%20message.%26nbsp%3B%20Is%20there%20more%20than%20one%20method%20to%20hyperlink%20a%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548729%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Hyperlink%20to%20PDF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548729%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738015%22%20target%3D%22_blank%22%3E%40RayZ1965%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20tested%20the%20same%20approach%20you%20used%20to%20follow%2C%20as%20long%20as%20you%20zip%20the%20folder%20and%20the%20linked%20pdf%20files%20are%20present%20in%20the%20folder%20it%20does%20seem%20to%20work%2C%20It%20could%20be%20an%20issue%20with%20office%20applications%20on%20your%20system%20the%20way%20links%20are%20being%20treated.%20A%20better%20approach%20would%20be%20to%20simply%20embed%20the%20file%20in%20excel%20as%20object%2C%20like%20in%20the%20article%20i%20shared%20above%2C%20that%20does%20increase%20the%20excel%20file%20size%20but%20at%20the%20same%20time%20saves%20you%20the%20hassle%20of%20sending%20out%20the%20entire%20folder.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Dear Excel 365 Users,

 

I am working on a project and the folder containing Excel and PDFs are saved to my local drive (laptop), since in prior Office version preserve the links and spreadsheet to share with my Team.

 

However, after using the same method, I opened the folder and spreadsheet this morning and have lost all hyperlinks.

 

How can I preserve a hyperlinked pdf in Excel?  I'm getting the following error message:

 

RayZ1965_0-1595522618452.png

 

3 Replies
Highlighted

Hey @RayZ1965 ,

 

Am a bit unsure about how you are doing this, but since you plan to share the document out to your team and you are embedding local links from your computer, wouldn't that cause an issue? If it fits your needs you can try embedding the pdf documents as objects in excel.

Ref: https://trumpexcel.com/embed-pdf-file-excel/

 

Thanks

Highlighted

@harveer singh Thank you.

 

Historically (prior Office versions), I link the pdf to the spreadsheet and save both Excel and PDF in the same folder.  If I share it with someone else, I zip the folder and e-mail it to a team member.  As a precautionary measure, I embedded the pdf to avoid losing my work product.

 

My issue is the hyperlinks are not working after I save the Excel and PDF in the same folder.  The following day, I go back to the hyper link and get the error message.  Is there more than one method to hyperlink a cell?

Highlighted
Best Response confirmed by RayZ1965 (New Contributor)
Solution

Hey @RayZ1965 ,

 

I just tested the same approach you used to follow, as long as you zip the folder and the linked pdf files are present in the folder it does seem to work, It could be an issue with office applications on your system the way links are being treated. A better approach would be to simply embed the file in excel as object, like in the article i shared above, that does increase the excel file size but at the same time saves you the hassle of sending out the entire folder.