how to share excel file with accessible (to others) embedded pdf links

%3CLINGO-SUB%20id%3D%22lingo-sub-1541630%22%20slang%3D%22en-US%22%3Ehow%20to%20share%20excel%20file%20with%20accessible%20(to%20others)%20embedded%20pdf%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541630%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20seen%20this%20question%20asked%20in%20several%20forums%20but%20never%20a%20solution.%20I%20have%20an%20Excel%20file%20I%20want%20to%20share%20with%20co-workers.%20Within%20the%20Excel%20file%20are%20links%20to%20pdf's.%20It%20seems%20like%20such%20a%20simple%20concept.%20I%20want%20my%20co-workers%20to%20be%20able%20to%20click%20on%20the%20icon%2C%20link%2C%20object%2C%20whatever%20and%20be%20able%20to%20open%20the%20attached%20pdf%20file.%20Can%20pdf's%20actually%20be%20uploaded%20or%20do%20they%20need%20to%20be%20stored%20in%20a%20shared%20folder%3F%20Thanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541630%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542385%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20share%20excel%20file%20with%20accessible%20(to%20others)%20embedded%20pdf%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542385%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F737998%22%20target%3D%22_blank%22%3E%40MFaulhaber2465%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ECouple%20of%20things%2C%20in%20order%20to%20link%20to%20a%20pdf%20in%20Excel%20(or%20any%20other%20file)%20right%20click%20on%20the%20cell%20you%20want%20the%20link%20in%20and%20select%20Link.%20Then%20navigate%20to%20the%20file%20itself%20and%20click%20OK.%20You%20can%20customize%20the%20text%20to%20display%20line%20in%20the%20example%20attached.%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%22Bennadeau_0-1595532939413.png%22%20style%3D%22width%3A%20838px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207545i64B8FBBE48306A4E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1595532939413.png%22%20alt%3D%22Bennadeau_0-1595532939413.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20being%20said%2C%20the%20file%20pdf%20file%20does%20need%20to%20be%20somehow%20accessible%20by%20the%20recipients%20computer.%20So%20yes%20a%20shared%20network%20drive%20is%20probably%20best.%20If%20the%20address%20link%20points%20to%20%22C%3A%5C...%22%20that%20is%20your%20local%20computer%20and%20it%20won't%20work%20well%20as%20the%20recipient%20computer%20won't%20know%20anything%20about%20your%20local%20computer.%26nbsp%3B%20If%20the%20link%20looks%20like%20%22%5C%5Cservername%5CsharedFolder%22%20and%20both%20your%20and%20the%20recipient%20computer%20can%20access%20that%20folder%2C%20you're%20in%20business.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20your%20other%20question%2C%20I%20don't%20believe%20you%20can%20merge%20a%20pdf%20in%20an%20Excel%20file.%20I%20like%20your%20thinking%20here%20though.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I've seen this question asked in several forums but never a solution. I have an Excel file I want to share with co-workers. Within the Excel file are links to pdf's. It seems like such a simple concept. I want my co-workers to be able to click on the icon, link, object, whatever and be able to open the attached pdf file. Can pdf's actually be uploaded or do they need to be stored in a shared folder? Thanks!!

1 Reply
Highlighted

Hi @MFaulhaber2465,

Couple of things, in order to link to a pdf in Excel (or any other file) right click on the cell you want the link in and select Link. Then navigate to the file itself and click OK. You can customize the text to display line in the example attached.

 

Bennadeau_0-1595532939413.png

 

 

That being said, the file pdf file does need to be somehow accessible by the recipients computer. So yes a shared network drive is probably best. If the address link points to "C:\..." that is your local computer and it won't work well as the recipient computer won't know anything about your local computer.  If the link looks like "\\servername\sharedFolder" and both your and the recipient computer can access that folder, you're in business.

 

To your other question, I don't believe you can merge a pdf in an Excel file. I like your thinking here though.