• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Static and Dynamic Links

Hi all,
I have an Excel sheet that has hundred of links.. It comprises static and dynamic links. When I converted this sheet to PDF, I noticed that the static links (the ones that begin with “https://”) work. The dynamic links (the one with no HTTPS but may have something like “Big Brooklyn Loaves”) do not work.

How can I change all the dynamic links to static links within the Excel document before I convert to PDF.? Or is there a better way of doing this?
I appreciate any help you can provide. (See attachment)
Frank.
 

Attachments

  • LINKS_TEST.xlsx
    13.8 KB · Views: 9
rows 7 and 11 were the only valid urls in the Excel file, when exported to pdf both those still worked from the pdf.
 
Back
Top