Creating PDFs in excel while preserving hyperlinks and "friendly names"

I need to create a PDF from an excel file and want to preserve the hyperlinks.  Also, the hyperlinks are created using a formula and I wish to use "friendly names" so the address of the link is not viewable.  From what I have read online this is my problem (i.e., Adobe will not recognize the hyperlink when friendly names are used).  Is there a way around this or is there a different product that could be used that will preserve the hyperlinks even with the use of friendly names?