Preserving links printing from Microsoft Excel to Adobe PDF?

Question

Hello, I have a question. I have picked my own brain, co-worker's brain, and husband's brain and no one can figure out how to do it, but we know it can be done. I have an excel spreadsheet that we would like to convert to a pdf file. The excel file has hyperlinks to various other documents on our network. How do we preserve the hyperlinks between the two programs? We know it can be done because our intern was using this same spreadsheet, converted to pdf, and maintained the links, but he didn't share his secret with the rest of us. We checked all of the print settings and looked through the "Help" sections of both Excel and Adobe to no avail. Any help would be greatly appreciated. Thanks!

Update:

No, there are a lot of links and that would have wasted a lot of time. We explored the option that maybe it wasn't a print but rather a conversion, but were still unable to figure it out.

AQuestionMark · Accepted Answer

It has something to do with the Create PDF Conversion Settings
See Tagged Adobe PDF section of this link
http://createpdf.adobe.com/cgi-feeder.pl/help_cpdf?BP=&LOC=en_US#tagged
Hope this helps

Anonymous · Answer

She probably printed to PDF and then manually inserted new links using Acrobat Professional.  Any print function is not going to capture formulas for links.

? · Answer

• launch Adobe Acrobat. you may get a loose 30-day trial from the Adobe internet site. • click "report" in the precise toolbar, then opt for "Open" from the drop-down menu. click on the PDF you % to transform and click "Open." • click the capital T icon in the precise toolbar, or carry down "Shift" and "V" on your keyboard. This activates Adobe Acrobat's Formatted text cloth opt for gadget. • click and drag your cursor over the table you % switched over. • suitable-click interior the chosen section and click "save As." • call the report and choose "*.txt" in the drop-down menu next to "save as form." click "save." • launch Microsoft Excel . • click "report" in the precise menu bar, then opt for "Open." click the text cloth report you created in Step 6 and click "Open." • click "next" in the conversion field that seems. Microsoft Excel will import the PDF documents and convert it into an Excel-formatted table. click "report," then "save" to save the spreadsheet in the XLS format. for extra help subsequently

Preserving links printing from Microsoft Excel to Adobe PDF?

3 Answers