Hello Everyone,
I know this question has been asked before, but I have not been able to find a satisfactory solution. When creating a PDF from Excel, hyperlinks appear to be active only when the destination URL itself is the link text, or when using Excels "insert link" function. Unfortunately these options do not work for me, as I create a product that requires the links to be updated dynamically through the HYPERLINK function, and these very long URLs are rather unattractive. Someone had mentioned first saving the workbook as a webpage and converting that to a PDF. This would work in theory, but is creating a disaster of formatting issues.
Could folks help think through solutions that either:
Thank you
I know this question has been asked before, but I have not been able to find a satisfactory solution. When creating a PDF from Excel, hyperlinks appear to be active only when the destination URL itself is the link text, or when using Excels "insert link" function. Unfortunately these options do not work for me, as I create a product that requires the links to be updated dynamically through the HYPERLINK function, and these very long URLs are rather unattractive. Someone had mentioned first saving the workbook as a webpage and converting that to a PDF. This would work in theory, but is creating a disaster of formatting issues.
Could folks help think through solutions that either:
- Enable the links directly in the PDF output (Is there any way to force Adobe to recognize the "friendly text" as a link?)
- Work around the problem in a way that is good enough (e.g., publish the full URL in invisible text, etc.)?
Thank you
