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?
